Weblogic Datasource Setup

How to create datasource for ADF application 11g/12c

• Goto Weblogic Console
• Select Data Sources on the Home Page
• Click New → Generic Data Source
• Enter the following and click Next
• Name: AppDataSource
• JNDI Name: jdbc/AppDS
• Database Type: Oracle
• Choose the JDBC driver type and click Next:
• Database Driver: *Oracle’s Driver (Thin) for Instance Connections; Versions: Any
• Leave the default Transcation Options and click Next :
• Enter the database connection properties and click Next :
• Database Name: TBD
• Hostname: TBD
• Port: TBD
• Database User: apps
• Password: TBD
• oracle.jdbc.DRCPConnectionClass: --Blank-

• Test the configuration and Click Next:
• Select the Target Server: It must be targeted to the cluster or servers where the ADF app is deployed (Exclude AdminServer from the target).
• And finish.

How to create XADatasource for SOA Suite 11g/12c

Datasource

• Goto Weblogic Console
• Select Data Sources on the Home Page
• Click New → Generic Data Source
• Enter the following and click Next
• Name: AppDataSource
• JNDI Name: jdbc/AppDS
• Database Type: Oracle
• Choose the JDBC driver type and click Next:
• Database Driver: *Oracle’s Driver (Thin XA) for Instance Connections; Versions: Any
• Leave the default Transcation Options and click Next :
• Enter the database connection properties and click Next :
• Database Name: TBD
• Hostname: TBD
• Port: TBD
• Database User: apps
• Password: TBD
• oracle.jdbc.DRCPConnectionClass: --Blank-

• Test the configuration and Click Next:
• Select the Target Server: It must be targeted to the SOA cluster or SOA managed servers (Exclude AdminServer from the target).
• And finish.
• Remember to create JNDI name to access this datasource from DB adapter or AQ adapter .
• This steps is only for SOA suite.

DB Adapter (Only for SOA)

• Select Deployments on the Home Page
• Click DbAdapter from the list
• Select tabs Configuration > Outbound Connection Pools
• Click on New button and select javax.resource.cci.ConnectionFactory
• Enter JNDI Name : eis/DB/apps
• This JNDI name should be same as the one entered in *.jca file.
• Click on Finish 
• Now expand the javax.resource.cci.ConnectionFactory and click on the JNDI name you just created.
• Enter the data-source name.
• For XA Datasources enter XADatasourceName
• For non-xa datasources just enter DatasourceName
• Remember to hit Enter on the keyboard as this form only registers data on keyboard enter.
• Click on Save button
• Go back to the Deployments page.
• Select the DbAdapter and click on Update
• Select Update option and click on finish
• If its the first time, the user will be asked to create a directory path for plan file. Choose the location when asked.

AQ Adapter (Only for SOA)

• Steps to create JNDI name for AQ adapter is same as DB adapter. It just needs repeating the above steps for AqAdapter in the deployments.