Wednesday, 7 September 2011

Create Database Resource in DBAdapter in Oracle SOA11g Part 2

Step 3: Create Connection Pool
* Click Deployments on tree menu
* Click DBadapter

* Click Configuration -> Outbound Connection Pools
* Click New

* Select javax.resource.cci.ConnectionFactory and click Next

* Enter
JNDI Name: eis/DB/mohanserver
and click Finish

* Click on Configuration tab -> Outbound Connection Pools
* Expand javax.resource.cci.ConnectionFactory
* Click eis/DB/mohanserver name

* Click Properties tab and enter
xADataSourceName: jdbc/mohanserver
* Hit Enter key
* Click Save button.

Step 4: (Redeploy)
* Click Deployments on left panel
* Select checkbox for Dbadapter

* Select Redeploy this application using the following deployment files

* Verify Deployment plan path
* Click Finish

Now you can use the Database Adapter with the JNDI name as eis/DB/mohanserver.

No comments:

Post a Comment