Posts

Showing posts from September, 2010

How to call Oracle Stored Procedures from data services

Image
An Oracle stored procedure is a program stored in an Oracle database which allows business logic to be embedded inside database as an API. You can expose the stored procedures as web services using wso2 data services server . This example takes you through creating a simple stored procedure in an Oracle DB and expose it as a data service using WSO2 Data Services Server . Pre-requisites: Download wso2 data services server from here Oracle 10g or later Step 1: Create and Populate sample database First, open sqlplus shell and log in to DB as follows. sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 23 22:52:01 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> connect sys as sysdba; Enter password: Connected. We should create a user and grant him the necessary privileges as follows. SQL> create user sample identified by sample account unlock; User created. SQL> grant connect to sample; Grant succeeded. SQL> grant create session, dba to sampl

How to start multiple WSO2 Carbon server instances as windows services

We can start more than one WSO2 Carbon (WSO2 ESB, WSAS, G-reg, GS, Mashup, IS, BPS, BRS, BAM, DS) instance by updating the transport configuration given in mgt-transport.xml (or transports.xml in 2.X series) as explained in here . Suppose, you need to start multiple carbon server instances as windows services instead of regular wso2server.sh executable. Then, there is an additional setting which has to be configured. Find wrapper.conf file inside CARBON_HOME/repository/conf Locate "Wrapper Windows NT/2000/XP Service Properties" section Update the Name of the service and Display name of the service in each instance as follows # Name of the service wrapper.ntservice.name=WSO2Carbon # Display name of the service wrapper.ntservice.displayname=WSO2 Carbon