Database Adapter Configuration

In this post how to configure the Database Adapter configuration using the weblogic Server console

To open the weblogic server on the browser in the Address bar type  http://localhost/console

Step1: Create Data Source

Step2: Give the connection to the Data Source by using connection pool

Step1:

In the console left side click on Service -> JDBC -> Data Sources

In that table click on NEW

Fill the data source information

1. Name: DBConfig
2. JNDI Name: JDBC/ DBConfig
3.  Database Type: Oracle
4. The Database driver defaults to the correct driver: Oracle's Driver (Thin XA) for Instance connections

Click on Next

Click on Next

Fill the database information:

1. Database Name: XE (database SID)
2. Host name: localhost
3. port: 1521
4. Database user name: system (what you created)
5. Database user password: admin (what you create)

 
Click on Next 

Click on Test Configuration (Confirmation for success message)

Click on Next

Select the Target Servers : AdminServer, soa_server1 

Click on Finish

2. Step2

Click on Deployments 

Click on the DBAdapter

Click on the Configuration Tab

Click on the Outbound Connection Pools

Click on New

Select the radio button for javax.resource.cci.ConnectionFactory and click on Next 

Enter the JNDI Name as: eis/DB/DBConfig (It uses the when you give database connection in JDeveloper)


Click on Finish


Select the deployment plan location and click on the plan.xml


Click on OK 


Now Click on the configuration tab


Click on the Outbound Connection Pools


Expand the Outbound Connection Pool Configuration Table and click on eis/DB/DBConfig


In the properties table, select the box to the far right of xADataSourceName

Type your datasource name what you created JDBC/ DBConfig and Press the Enter key 

Select Save button to save the value

Click on the Deployments in the left side and select DbAdapter and select the checkbox 


Click on Update

Select Redeploy this application using the following deployment files:

click on Finish