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!

Whatever you do, make sure that you don't use Apache's DBCP. It's a horrible implementation that will actually cause performance problems, not fix them. — erickson
– erickson, Commented Dec 1, 2008 at 4:43

carson · Accepted Answer · 2008-12-01 00:36:03Z

7

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.

answered Dec 1, 2008 at 0:36

carson

5,7593 gold badges27 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sagi Bron · Accepted Answer · 2011-04-14 14:31:45Z

0

You can easily implement MySQL connection pooling in Java by using Java's GenericObjectPool that provides robust pooling functionality for arbitrary objects.

See detailed example in this post: How to set up a MySQL connection pool in Java

answered Apr 14, 2011 at 14:31

Sagi Bron

273 bronze badges

1 Comment

Jonathan S. Fisher Over a year ago

This isn't correct at all. You should use the built in pooling in Tomcat.

Collectives™ on Stack Overflow

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

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related