I'm building a web app that uses servlets to connect to a mysql database. I'm looking for a solid implementation of a connection pool that I can use. I don't have access to the Tomcat server configuration, so I'm looking for a library that implements the connection pool from within the servlet itself.

Any suggestions?

Thanks in advance!

robin

What does this question have to do with MySQL? This should be moved to the Java forum.

Tomcat contains the Apache DBCP (http://commons.apache.org/dbcp/) connection pool, so you should be able to directly access that. If not, you can download the library from their homepage.

I'm connecting to a mysql database, but you're probably right -- the connection pool is generic wrt the particular DB being used.

You may use also C3P0 (hibernate use it.)
Dimis