How to create a Non-XA DataSource in WebLogic Server 11g console.

In this post you will learn how to create a Non-XA Datasource in the Weblogic server 11g console. To achieve this follow below steps –

1) Login to Weblogic server console using http://<hostname>:7001/console.

2) Go to the Domain structure as shown in the screen print –

3) You will view the  below screen.

4) In order to enable the ‘New’ button click on the ‘Lock & Edit’ button under ’Change Center’ on the top left corner.

5) Click on the ‘New’ button under ‘Data Sources (Filtered – More Columns Exist)

6) While creating the Datasource, for Non-XA Datasource select the ‘*Oracle’s Driver (Thin) for Instance connections; Versions:9.0.1.9.2.0.10.11’ as shown –

7) While creating the Data source you need to mention the JNDI value as jdbc/(your DB connection name) ex:jdbc/jamesxedb as shown below –

8) Now you need to add this Data source (jamesxedb) in the DBAdapter connection pool. Go to Deployments link.

9 ) click the  DBAdapter link

10) Create a new connection pool tab and specify the same JNDI value (eis/DB/jamesxedb) which you used while creating the DBAdapeter in Jdeveloper.

11) Now select the newly created connection pool (eis/DB/jamesxedb) and in XADatasourceName field enter the (jdbc/jamesxedb) as shown

12) Now you need to update the deployment plan. Go to Deployments –> Select DBAdapter –> Click on Update button as shown –

Accept all the default values in the next screen flow and click Finish. By this the Non-XA data source is successfully registered in the Db Adapter connection pool.

Note: Don’t forget to Update Deployment Plan for the DBAdapter under Deployments.

Advertisements
This entry was posted in BPEL, Oracle Service Bus (OSB), Service Oriented Architecture (SOA 11g), WebLogic Server 11g and tagged , , , , , . Bookmark the permalink.

One Response to How to create a Non-XA DataSource in WebLogic Server 11g console.

  1. Deb says:

    JDBC name should not be put in xaDatasource name if you are creating nonXAdatasource.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s