Use of DB Adapter in SOA Composite Application

I successfully create SOA Composie Application that interact with Oracle Database by using DB Adapter. The Oracle Database Adapter enables a BPEL process to communicate with Oracle databases or third party databases through JDBC.

The Oracle Database Adapter service is defined within a BPEL process partner link by using the Adapter Configuration Wizard of Oracle BPEL Process Manager.

BPEL Process of my DB Adapter

Database and JNDI Name Configuration

Testing Web Service

In this Web Service i am retrieving data from HR schema by giving the employee ID as input parameter and Web Service returns employee name and its salary.


Popular posts from this blog

How to create Oracle stored Procedures using TOAD for Oracle

How to Create Packages in Oracle Database using TOAD for Oracle

Create Tables in Oracle Database using TOAD