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.
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.
Hi Gupta,
To configure the DataSource in Connection Pool in Weblogic 10.3.5 follow the steps in the below link.
http://download.oracle.com/docs/cd/E21764_01/web.1111/e13737/jdbc_datasources.htm#i1167511
Thanks,
Udaya
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
It’s remarkable for me to have a site, which is valuable for my know-how. thanks admin
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
Greetings! Very helpful advice in this particular article!
It’s the little changes that will make the most important changes. Many thanks for sharing!
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…?
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…?
Thank you so much. It helped me a lot. Keep up the good work!