Connection Pooling with MySQL Connector/J

Mark Matthews

In last month's article, "Does MySQL Connector/J Support Multithreaded Programming?" (http://www.mysql.com/newsletter/2003-04/a0000000154.html), I covered the problems with sharing a JDBC connection between multiple threads. Most of these problems can be overcome with a technique called "connection pooling." In addition to fixing the problems mentioned in the previous article, connection pooling generally leads to more predictable resource usage under load, and allows deployment of applications on smaller or less-powerful hardware than would be normally required. You can read the full article at http://www.mysql.com/articles/connection_pooling_with_connectorj.html