Oracle Fusion Middleware

The following steps describes how to create a JNDI location so you can use it later on your DbAdapter
(The configuration is done on Oracle EM 10g(10.1.3.1) Application Server Control):

1. Create a Connection Pool

In the EM click on your OC4J server (where Bpel PM exists in):

Go to Administration tab. Under Services ->JDBC Resources, press the “Go to Task” button:

In the Connection Pool table press the Create button:

Leave the default values and press continue:

Fill in the DB parameters, test the connection, and press Finish:

2. Create Data Source

Repeat the previous steps, and under Data Source table press the Create button:

Leave the default values and press continue:

Fill the parameters (choose the connection pool from step 1, and in the Transaction Level choose Global & Local Transactions). Press Finish:

3.  Create JNDI

Go back to the main EM screen (Cluster Topology). Open the “+” of your OC4J server, and click on default:

Under the Home tab/Modules table click DbAdapter:

Go to Connection Factories tab and press the create button:

Leave the default value and press continue:

Fill in the JNDI name (like eis/DB/xxx). In the xADataSourceName field put your Data source name (jdbc/xxx) and press Finish:

That’s it. Restart your OC4J.

Good luck