wood burning stoves*
The moose likes JDBC and the fly likes Connection Pool Question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection Pool Question" Watch "Connection Pool Question" New topic
Author

Connection Pool Question

Gavi Raaghav
Ranch Hand

Joined: Apr 28, 2005
Posts: 82
I am using the connection pool through the WAS. I connect to multiple databases so is there only 1 connection pool created which caters to all the DB's or there is 1 connection pool allocated to every DB?
Jesper de Jong
Java Cowboy
Saloon Keeper

Joined: Aug 16, 2005
Posts: 14074
    
  16

One connection pool contains only objects that point to the same database. All the connection objects in the pool are the same.

So if you connect to two databases, you need two connection pools, one for each database.


Java Beginners FAQ - JavaRanch SCJP FAQ - The Java Tutorial - Java SE 7 API documentation
Scala Notes - My blog about Scala
JuanP barbancho
Ranch Hand

Joined: Oct 25, 2005
Posts: 52
Weblogic have multipool, but I unknow the use of them
 
Don't get me started about those stupid light bulbs.
 
subject: Connection Pool Question
 
Similar Threads
enterprise application with many users
Clean-up objects in session.
Mock question
Testing Connection Pool in Weblogic6.1
recreating damaged connection in pool