579 total views, 1 views today

 

Database Adapter configuration in WebLogic Server

Oracle database adapter 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: a 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 DB adapter is XML message. The DB adapter received XML message from SOA apps and response back XML message to SOA apps, so it is loosely modeled and it easily plugs into SOA application.

DB adapter can 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 to connect to Database.

 

052016_0257_DatabaseAda1 Database Adapter configuration in WebLogic server

In this section, we talk about how to create a JDBC data source and a DB adapter in Weblogic 12C. I have used  HR Schema comes with Oracle database 

 

Pre-Requisite

Oracle WebLogic 12C

HR Schema (Bundles with Oracle database)

 

Create JDBC Datasource

 

Login into  the 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 instructions to create an SOA project (BPEL) that connects a DB adapter instance.

govindan Database Adapter configuration in WebLogic server
Connect me

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 🙂
govindan Database Adapter configuration in WebLogic server
Connect me
By | 2017-09-28T21:21:06+00:00 May 19th, 2016|Categories: WebLogic|Tags: , , |1 Comment
  • Sanjay Dhanwani (SanjayMD)

    Hi govind
    Thanks a lot for detailed post.
    Can you please share what is the difference between selecting “update” vs “redeploy” this application in last stage of adapter update ?

    Thanks a lot
    Sanjay

Like us on Facebook.
Connect!