SOA 11g: Configure DBAdapter

Establish a DBAdapter Deployment Plan Directory

* Create a directory on the host machine where the deployment plan for the DbDapter application can be saved.
* This only needs to be done once.
* Example:

mkdir /opt/oracle/Middleware/home_11gr1/Oracle_SOA1/soa/DBPlan

Acquire Change Lock

* Click Lock & Edit button in the Change Center pane.

Create a Data Source

* To create a Data Source to point to your database.
* Example:
- Name: myDS
- JNDI Name: jdbc/myDS

Create an Outbound Connection Pool

* Click soa_domain > Deployments in Domain Structure pane.
* Click DBadapter in Summary of Deployments pane.
* Click Configuration -> Outbound Connection Pools tab.
* Click New button.

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

* Enter
JNDI Name: eis/DB/myDB

* Click Finish.

Assign Data Source to Connection Pool

* Click Configuration tab -> Outbound Connection Pools tab.
* Expand javax.resource.cci.ConnectionFactory.
* Click the newly created outbound connection pool, e.g eis/DB/myDB.

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

Redeploy DbAdapter

* Click soa_domain > Deployments in Domain Structure pane.
* Click thecheckbox to select DBAdapter.

* Click Update button.
* Select Redeploy this application using the following deployment files
* Check deployment plan file is correct:
- Deployment plan path: /opt/oracle/Middleware/home_11gr1/Oracle_SOA1/soa/DBPlan/Plan.xml

* Click Next.
* Click Finish.

Activate Changes

* Click Activate Changes button in the Change Center pane.