How to create JDBC Resources from EM for SOA 10.1.3.X

================================================================
1) Goto EM console
2) Click OC4J_SOA->Administration Tab
3) Services->JDBC Resources
4) Create ‘Connection Pool’

a) Application ‘default’
b) New Connection Pool say ‘MyDSCP’
c)Give Unique name, JDBC URL and Credentials

5) Create ‘Data Sources’

a) Application ‘default’ next ( Managed Data source . selected)
b) Connection pool from List ‘MyDSCP’
c) Name ‘MyDS’, JNDI ‘jdbc/MyDS’, Connection Pool ‘MyDSCP’

6) Now Goto OC4J_SOA->Applications->default->DbAdapter->ConnectionFactories

a) Create choose default
b) JNDI Location ‘eis/jdbc/MyDS’
c) xADataSourceName =‘jdbc/MyDS

-----------------------------------------------------------------------------------------

For 11g SOA Refer:

http://download.oracle.com/docs/cd/E14571_01/integration.1111/e10231/life_cycle.htm#BABBEDBF