How to use connection pool with java,MySQL and Tomcat 6

Question

How can I use Connection pool in Java+MySQL+Tomcat 6?

I've read this article http://dev.mysql.com/tech-resources/articles/connection_pooling_with_connectorj.html but it is still not quite clear for me.

Where do I use the Connector/J? Do I put it in a static variable? Do I use a SessionListener? Does it need any configuration?

Thank you in advance!

Solution

You should read the Tomcat 6 JNDI document. Look for the "JDBC Data Sources" section and it will tell you everything you need to know about pooling connections with Tomcat.