<p>How can I use Connection pool in Java+MySQL+Tomcat 6? </p>

<p>I've read this article <a href="http://dev.mysql.com/tech-resources/articles/connection_pooling_with_connectorj.html" rel="noreferrer">http://dev.mysql.com/tech-resources/articles/connection_pooling_with_connectorj.html</a> but it is still not quite clear for me. </p>

<p>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?</p>

<p>Thank you in advance!</p>

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.