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 pooling 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 pooling" Watch "connection pooling" New topic

connection pooling

Vijayalakshmi Karthikeyan

Joined: Jul 23, 2010
Posts: 27
Hi all,
Can we create a connection pooling for multiple database. If possible Can you please guide me with sample code..
Jan Cumps

Joined: Dec 20, 2006
Posts: 2565

Yes, this is possible. You can create a connection pool for each of your databases.
When you need a connection for a particular database, you ask one from the corresponding pool.
When you later close that connection, it will be automatically given back to the right pool.

OCUP UML fundamental and ITIL foundation
Kunal Lakhani
Ranch Hand

Joined: Jun 05, 2010
Posts: 622
1st you need to configure Tomcat 5.5 with admin console. After configuring that Create a helper class. Use JNDI to look up the connection. Create a static method to get connection(the return type for which is Connection)

I am providing you some part of the code

Whenever you want to create a connection( logical connection), just call Classname.getConnection. (in my case DbUtil.getConnection)

I agree. Here's the link:
subject: connection pooling
It's not a secret anymore!