IntelliJ Java IDE
The moose likes EJB and Other Java EE Technologies and the fly likes How to create a connection pool in weblogic 6.0 Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Java » EJB and Other Java EE Technologies
Reply Bookmark "How to create a connection pool in weblogic 6.0" Watch "How to create a connection pool in weblogic 6.0" New topic
Author

How to create a connection pool in weblogic 6.0

arindam samanta
Greenhorn

Joined: Nov 20, 2001
Posts: 1
Hi,
I installed the weblogic 6.0. I want to create my one own connection pool there. I modified config.xml file still i could not create the connetion pool.
would u tell me how to create connectiopn pool with xml code..and also how i know connection pool is created.
Vijay Shrivastava
Ranch Hand

Joined: Nov 15, 2001
Posts: 64
After you have installed the WLs6.1 Configuring the connection pool is very easy if you try from console. I will not recommend doing t from config.xml as it doesn't take all the parameter's directly.
1. Start the server.
2. logon to server in administrator mode http://loclahost:7001/console it will ask for login and password.
3. Select the server from the left pane (myserverif default).
4. Go to Databases tab.
5. Create connection pool. On the right pane you will have 3 tabs which are important. In first one you will specify the Database URL and the driver. In properties section You will specify the username ad the password. on separate line just like properties file.
6. On another tab you will specify maximum connection and initial number of connection etc. Make sure initla number ir greater than 1.
7. You have to add this pool to the Myserver which is done on separate tab without it connection pool is not available.
8. You may need to define the Datasources for This connection pool Which may be nonjts and jts datasources. There is separate selection unders database/jdbc in left pane. Make sure that you add this datasources to your server. And give them the same pool.
9. Go to Myserver and on the right pane select the general tab(i am not sure which one but one of the tab has the option for logging level) make it warn.
10. When you start the WLS server again you will see if Connectionpool is created or not it will also give any errors in log.
hopw it helps,

------------------
Vijay shrivastava
Consultant - ObjectNetTechnologies ,Atlanta USA.
SCJP2, SCJEA (Part I)


Vijay shrivastava
 
IntelliJ Java IDE
 
subject: How to create a connection pool in weblogic 6.0
 
Threads others viewed
connection pooling in weblogic 11
connection pooling in tomcat
Connection pooling
Using OracleOCIConnectionPool in WebLogic 6.1
Doubt On Connection Pool
developer file tools

cast iron skillet 49er

more from paul wheaton's glorious empire of web junk: cast iron skillet diatomaceous earth rocket mass heater sepp holzer raised garden beds raising chickens lawn care CFL flea control missoula heat permaculture