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

Mike Southgate
Ranch Hand

Joined: Jul 18, 2003
Posts: 183
I'm writing a web app that will support an unknown number of concurrent users, so I need to establish some sort of database connection pooling. In another forum someone implied that JNDI provided some support in this respect. Could anyone here elaborate?

ms<br />SCJP, SCJD
Faisal Khan
Ranch Hand

Joined: Jun 29, 2003
Posts: 285
Hi Mike,
I had the same question yesterday and the answer I got back was that I don't particularly need to use a database connection pooling package since Tomcat (not sure what you are planning to use) will allow me to setup and JNDI datasource.
If you are using an app server they mostly (I think) have the connection pooling facility. With tomcat, if you follow the instructions here:, you can very easily setup the connection pooling, tomcat uses DBCP.
Ofcourse, another option is to use the DBCP package directly, you can get the package from Jakarta website.
I hope this helps.

The secret to creativity is knowing how to hide your sources.
javen fang

Joined: Jun 29, 2003
Posts: 4
Resin also offer Connection Pool

I believe I can fly<br />...................<br /> Just do it !!!
I agree. Here's the link:
subject: Connection pooling
It's not a secret anymore!