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
Hi, Thanks for sharing the information. Reading this article gave me many things to think about.