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:
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html, 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.