Tomcat 5.5 Configuring Mysql Database Connection Pool

With the latest few buzz, I finally figured out the Tomcat 5.5 configure the Mysql database connection pool. Online experience could not be fully used in the new environment, I wrote the whole process for convenience.

1 Environment Description JDK 1.5 Tomcat 5.5.4 mysql 4.0.20 MySQL JDBC 3.0.15 Commons DBCP 1.2.1

2 Prepare work JDK, Tomcat, MySQL installation process is not my focus, slightly. Download mysql-connector-java-3.0.15-ga.zip from http://dev.mysql.com/downloads/, put the mysql-connector-java-3.0.15-ga-bin.jar in JRE / LIB / EXT and Tomcat 5.5 / Common / lib are inside. Download Commons-Dbcp-1.2.1.zip from http://jakarta.apache.org/commons/dbcp/, put the common-dbcp-1.2.1.jar in JRE / LIB / EXT and Tomcat 5.5 / Common / lib insteit.

3 Configuring Tomcat Add: . Add: mysql connection pool JDBC for mysql < / res-ref-name> javax.sql.datasource Container in Tomcat 5.5 / WebApps / Test / Meta Add: