File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Connection Pool Question Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of Mongo DB Applied Patterns this week in the MongoDB forum
or a resume review from Five Year Itch in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Reply 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
Bartender

Joined: Aug 16, 2005
Posts: 12907
    
    3

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
 
I agree. Here's the link: http://zeroturnaround.com/jrebel
 
subject: Connection Pool Question
 
Similar Threads
Testing Connection Pool in Weblogic6.1
Mock question
Clean-up objects in session.
enterprise application with many users
recreating damaged connection in pool