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

In this post you will learn how to create a 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 Data source you need to mention the JNDI value as jdbc/(your DB connection name) ex:jdbc/jamesxedb as shown below –

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

8) click the  DBAdapter link

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

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

11) 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 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 Jdeveloper, WebLogic Server 11g and tagged . Bookmark the permalink.

9 Responses to How to create a DataSource in WebLogic Server 11g console.

  1. Gupta says:

    Hi Uday,
    I am using weblogic 10.3.5.0 and I followed this article to add a DataSource upto 8th step it is clear and coming to 9th step i can’t find “Outbound Connection Pools” tab under Configuration tab. Can you please help on that ?

    Thanks & Regards,
    Gupta katakam.

  2. sandip says:

    hi,
    I am using web logic 8.0..plz guide me to configure the DS…..i m fully confused with the configuration…..i need help…plz help me asap……..
    thanks
    sandip

  3. It’s remarkable for me to have a site, which is valuable for my know-how. thanks admin

  4. Ram says:

    Hi,

    I am using Oracle BPM11g virtual box. While I am trying to create a datasource in weblogic console. I am getting below error.

    Message icon – Error An error occurred during activation of changes, please see the log for details.
    Message icon – Error weblogic.application.ModuleException:
    Message icon – Error Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

    When I am testing the DB connection, I m getting a success message. But When I am activating changes I am getting above error. Please help.I am able to connect to DB in Jdeveloper.

    I tried searching in previous posts but I couldn’t get. Please help.

    Thanks

  5. Greetings! Very helpful advice in this particular article!

    It’s the little changes that will make the most important changes. Many thanks for sharing!

  6. akray says:

    In Weblogic server > under Deployments tab > .WAR (deployed) > Monitoring.> {SESSIONS / TOTAL SESSIONS / SERVLETS/ MAX SESSIONS/ }
    iam using a web application having Weblogic has Application server
    What does it indicates? Sessions means no of user Connections or noof Http sessions? Is it right? Also how can know how many are connected to application? Also what’s the limit of weblogic serevr ? upto how many sessions or connections will it bears? Iused round robin method of clustering… but failed in our app…..do we have any effective methods…?

  7. ram says:

    uday can u help me regarding in weblogic serevr

    In Weblogic server > under Deployments tab > .WAR (deployed) > Monitoring.> {SESSIONS / TOTAL SESSIONS / SERVLETS/ MAX SESSIONS/ }
    iam using a web application having Weblogic has Application server
    What does it indicates? Sessions means no of user Connections or noof Http sessions? Is it right? Also how can know how many are connected to application? Also what’s the limit of weblogic serevr ? upto how many sessions or connections will it bears? Iused round robin method of clustering… but failed in our app…..do we have any effective methods…?

  8. Thank you so much. It helped me a lot. Keep up the good work!

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