How to Create JDBC datasource in Oracle Weblogic server

How to Create JDBC datasource in Oracle Weblogic server

This post shows how to create a JNDI datasource in Oracle Weblogic 11g.

To work on DB adapter in Oracle SOA suite you must create the JDBC datasource in Oracle Weblogic Server and Connection factory under DBadapter in deployments.

Steps:
1. Login to weblogic console (normal http://localhost:7001/console) as administrator.

2. Click on DataSource

3. Click New > Generic Datasources. 

4. Fill in name, JNDI name, and choose Database type, then click Next

5. Choose Database Driver > Click Next

6. Enter JDBC Connection Details

7. Review & Test the Connection. Should be connection test succeeded. 

8. Select Target Server & Click Finish