File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 and Relational Databases
Bookmark "Connection Pool Question" Watch "Connection Pool Question" New topic

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: 15091

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 8 API documentation
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:
subject: Connection Pool Question
It's not a secret anymore!