Creating DataBase Resource

You create this using the WebLogic Server console. First create the data source and then a connection pool for that data source.

Start WebLogic Server.--http://localhost:7001/console, Enter Username and Password

On the left navigation bar, Click Services > JDBC > Data Sources.
In the data source table, click New

Enter the data source information
Name:demoDataSource
JNDI Name: jdbc/demodatasource
Database Type: Oracle
The Database driver defaults to the correct driver: Oracle’s Driver (Thin XA) for Instance connections

Click Next, click Next again


As Per your configurations:
For example as below:
Database Name: XE (your database SID)
Host name: localhost (host where your database is running)
Port: 1521 (set according to your configuration)
Database user name: soademo
Database user password: soademo

Click Next
Click Test Configuration. Confirm success message at top of page.
Click Next
Select the Target server where your SOA component is running:soa_server1.
Click Finish

First before Configuring DB adapter, click on Deployements and select DB adapter and stop it.

Now click DB Adapter

select configuration

click on outbound connection pools as below

Click on New, select Connection Factory

JNDI Name -> eis/jdbc/demodatasource

Click Finish

Expand javax.resource.cci.ConnectionFactory

Click on JNDI name:- eis/jdbc/demodatasource

Configure has XADataSourceName--> jdbc/demodatasource ( Previously we have created datasource JNDI name), After entering immediately click Enter button, then SAVE

Redeploy DBAdapter

  Select DB Adapter, Click UPDATE

     

Select, Redeploy this application using the following deployment files:

Click Finish.

Activate All changes

Start DB Adapter

To access Database from Jdeveloper, JNDI name to use is eis/jdbc/demodatasource