Database Adapter in OSB 11g

Database Adapter in OSB 11g

Oracle Service Bus does not have facility to create the Database Adapter directly (In Eclipse OEPE does not have option to create the DB Adapter). To achieve this, we can use the Oracle JDeveloper to create the DB Adapter and then import the resources like JCA, wsdl and xsd into the OSB project from JDeveloper. Using above mentioned files we can avail the DB Adapter features in OSB.

Steps:

1. Create Database Adapter using oracle Jdeveloper.

2. Import .jca, wsdl, and xsd files into the OSB project and create business service using .JCA 

3. Create Datasource and connection factory in weblogic server.

1 Create Database Adapter using oracle Jdeveloper.

Create a new SOA project in Jdeveloper.

Drag and drop a DB Adapter in the composite; it opens DB Adapter configuration wizard.
Provide service Name, JNDI Name and select the operations which would you like to perform in Database as select, update and delete.

Import the table 

Click next to all the windows and Finish.

Now the DBAdapter, JCA, wsdl and xsd file has created in Jdeveloper.

2 Import the Resources into the OSB project and create business service using JCA file.

a) Create OSB Configuration and OSB project if you don’t have it already.

b) Right click in newly created OSB project and select import > import. It opens import window, in General select File Systems and click next. 

c) Goto the Jdeveloper project location and select the .jca, wsdl, and xsd file and click finish.

d) Now the files are copied into your osb project.

e) In .jca file right click select Oracle Service Bus > Generate Service.

f) It creates business service for you.

g) Open the business service (.biz file) and select “Transport” tap at bottom, check the protocol is selected as “jca”.

This business service act as interface for Database. Open the JCA file and see the JCA configuration details.

Create Data source and connection factory in weblogic server.

a) Login to weblogic console goto JDBC > Datasource , Create Datasource with JNDI alias

b) In weblogic Domain Structure select Deployments > select DbAdapter > Configuration > Outbound Connection pool > New

c) Give the JNDI name, it should match the name which one u given while creating the DB Adapter.

d) Goto the Outbound Connection property > edit the property value of xADataSourceName and hide Enter key to save it. (jdbc/testDatasource)

e) Update the DbAdapter to activate the configuration changes.

f) Deploy the business service and test.