Database Adapter configuration in WebLogic server

Home/WebLogic/Database Adapter configuration in WebLogic server

Database Adapter configuration in WebLogic Server

Oracle database connector is a JCA connector, which is a DBAdapter.jar file deployed to the WebLogic server during the installation of FMW. The DB adapter enables the Oracle SOA Suite application (ex: BPEL process) communicate to the Oracle database via a JNDI data source. The DB adapter relies on the JDBC driver to establish communication. The interaction between the SOA application to the Oracle database via the adapter is XML message. The DB adapter received XML message and response back XML message, so it is loosely modeled, so it easily plugged into SOA application.

DB adapter consist of multiple instances, Each instance (example: eis/DB/HR ) points to a single database and the instance must map with a JNDI data source

052016_0257_DatabaseAda1 Database Adapter configuration in WebLogic server

In this section, we talk about how to create a JDBC data source and configure DB adapter for HR Schema in WebLogic 12C.

Pre-Requisite

Oracle WebLogic 12C

HR Schema (Bundles with Oracle database)

Create JDBC Datasource

Login into WebLogic Server

052016_0257_DatabaseAda2 Database Adapter configuration in WebLogic server

Expand Services >> Click New >> Select Generic Data Source

052016_0257_DatabaseAda3 Database Adapter configuration in WebLogic server

Input a Name >>input a JDBC Name (format is jdbc/<SCHEMANAME>) >> Database type as Oracle >> Click Next

Note: Copy this JNDI name in a notepad file, we need this name to configure DB adapter

052016_0257_DatabaseAda4 Database Adapter configuration in WebLogic server

Click driver as Oracle >> Click Next

052016_0257_DatabaseAda5 Database Adapter configuration in WebLogic server

Click Next

052016_0257_DatabaseAda6 Database Adapter configuration in WebLogic server

Input the Database connection configuration >> Click Next

052016_0257_DatabaseAda7 Database Adapter configuration in WebLogic server

Click the button Test Configuration >> Verify the connection result

052016_0257_DatabaseAda8 Database Adapter configuration in WebLogic server

Enable the server >> Click Finish

Note: Please point the server where you want to have the data source available. You may enable datasource to AdminServer, Cluster, Managed servers based upon how WebLogic configured.

052016_0257_DatabaseAda9 Database Adapter configuration in WebLogic server

The JDBC Data Sources wizard will list the data source that we created above

052016_0257_DatabaseAda10 Database Adapter configuration in WebLogic server

Configure datasource in DBAdapter

Click on the Deployments >> Click Next >> Click DbAdapter

052016_0257_DatabaseAda11 Database Adapter configuration in WebLogic server

Click Configuration >> Click Outbound Connection Tools >> Click New

052016_0257_DatabaseAda12 Database Adapter configuration in WebLogic server

Click Next

052016_0257_DatabaseAda13 Database Adapter configuration in WebLogic server

Input your instance name (eis/DB/HR), You will need this name in your SOA application to create DB Adapter

052016_0257_DatabaseAda14 Database Adapter configuration in WebLogic server

Click Ok

052016_0257_DatabaseAda15 Database Adapter configuration in WebLogic server

It will display the successful message >> Click Ok

052016_0257_DatabaseAda16 Database Adapter configuration in WebLogic server

Now click the Configuration >> Outbound Connection Pools >> Click the instance (eis/DB/HR) we created above

052016_0257_DatabaseAda17 Database Adapter configuration in WebLogic server

Click on the propertyValue against the XADataSourceName >> Input the JNDI name (jdbc/HR) >> Hit Enter button on your keyboard >> Click Save

Note: we highlighted the JNDi name in green colour above

052016_0257_DatabaseAda18 Database Adapter configuration in WebLogic server

You will notice the successful message as shown below >> Click Save

052016_0257_DatabaseAda19 Database Adapter configuration in WebLogic server

Click Deployments >> Click Next >> Enable the checkbox for DBADapter >> Click Update

052016_0257_DatabaseAda20 Database Adapter configuration in WebLogic server

Click the box ‘Update this application in place with new deployment plan changes. (A deployment plan must be specified for this option)’ >> Click Update

Note: If you are configuring the DB adapter in a clustered environment then copy the plan.xml file to the other machine before the update. The plan.xml file location is mention in the Deployment Plan path as shown in the picture below

052016_0257_DatabaseAda21 Database Adapter configuration in WebLogic server

Success message appears on the screen, Restart the WebLogic server for the changes take effect

052016_0257_DatabaseAda22 Database Adapter configuration in WebLogic server

 

That’s it. We have configured a database connection in DBAdapter. Now use this DB adapter information in your SOA application. Click here for instruction to create an SOA project (BPEL) that connects a DB adapter instance.

pgn Database Adapter configuration in WebLogic server

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply 🙂
pgn Database Adapter configuration in WebLogic server
By | 2016-05-19T23:47:56+00:00 May 19th, 2016|Categories: WebLogic|Tags: , , |0 Comments
Like us on Facebook.
Connect!