This is in continuation of my last post on Database Connectivity (JDBC) in WebLogic Server here , In today’s post I am going to cover step by step JDBC configuration using Administration Console.

1. Login to WebLogic Server Administration console (default port 7001)
http://hostname:port/console

2. Select Data Sources under JDBC in Services section
.

.

3. Click on New button on right side as shown above

4. Enter JDBC Name, JNDI Name, Database & Driver type as shown below

.

. 

5. In next screen, enter database connection pool details i.e.
– Database Name
– Host Name (on which database is running)
– PortNumber (on which database listener is listening)
– Database User Name
&
– Password (for database user)

. 

6. In next screen you test connection by clicking on “Test Configuration” as shown below

.

. 

7.Finally you select target servers (Administration and Managed Server in that domain) for that Datasource.

. 

8. On clicking Finish button, you should see datasource as listed below

. 

To create Multi Datasource

Steps mentioned above are to create single Datasource. To create Multi Datasource first create two or more Datasource as mentioned above (I created JDBC1 & JDBC2)  then select Multi Datasources from console as shown below
.

. 

2. Click on New button above, In next screen select Name of Multi Datasource and JNDI
.

.

3. Select Algorithm Typefor Multi Datasource i.e. Failover or Load Balancing

4. Select Datasource which you want to make part of Multi Datasource as shown below 

.

. 

5. Finally click on Finish to see Multi Data Sources

JDBC tuning in WebLogic and lot more coming soon…

Previous in series Next in series

Related Posts for Learn WebLogic with Us


  1. Oracle WebLogic Installation Steps
  2. Domain , Administration & Managed Server, Cluster in Oracle WebLogic
  3. Create Domain in Oracle WebLogic
  4. Oracle WebLogic Server - Startup/Shutdown
  5. Oracle WebLogic Server 10g R3 10.3 is out now
  6. Deploy Application on Oracle WebLogic Server
  7. Cluster Architecture : Oracle WebLogic Server
  8. Start WebLogic Server on Linux on port 80, 443 <= 1024
  9. JDBC (Java DataBase Connectivity ) in Oracle WebLogic - Overview
  10. WebLogic Server JDBC for Database connection : Step by Step
  11. Security in Oracle WebLogic : Realm, Security Provider, Authentication, Authorization, Users
  12. Deploy ADF application to Oracle WebLogic Server
  13. Node Manager in Oracle WebLogic Server
  14. Configure Oracle HTTP Server infront of Oracle WebLogic Server mod_wl_ohs
  15. How to install weblogic server on 64 bit O.S. (Linux /Solaris) ?
  16. Oracle WebLogic Login Issue : Password is not correct (Password Lock Policy)
  17. Oracle WebLogic Server : Node Manager in nutshell
  18. Certification : 1Z0-108 Oracle WebLogic Server 10g System Administrator Certified Expert
  19. How to integrate WebLogic with Oracle Internet Directory for Login : Authentication
  20. opatch, adpatch and now “smart update” (BSU) to apply weblogic patches
  21. Disater Recovery documentation for Oracle WebLogic Server 11g (Fusion Middleware)
  22. Authentication Providers in #WebLogic - Oracle Access Manager Identity Assertion for Single Sign-On and OAM Authenticator
  23. Error while starting WebLogic Server : java.lang.NumberFormatException: null
  24. #WebLogic startup prompting from username password : boot.properties

Popularity: 11% [?]

Share This