Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
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: 14951

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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: Connection Pool Question
It's not a secret anymore!