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
* Follow this post 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.
5 Responses to SOA 11g: Configure DBAdapter