Shulou(Shulou.com)06/01 Report--

Tomcat 5.5 Configuring MySQL Database Connection Pools [@more@]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 Preparations

JDK, Tomcat, MySQL installation process is not my focus, skip it.

Download mysql-connector-java-3.0.15-ga.zip from http://dev.mysql.com/downloads/and place mysql-connector-java-3.0.15-ga-bin.jar in jre/lib/ext and Tomcat 5.5/common/lib.

Download commons-dbcp-1.2.1.zip from http://jakarta.apache.org/commons/dbcp/and place commons-dbcp-1.2.1.jar in jre/lib/ext and Tomcat 5.5/common/lib.

3 Configuring Tomcat

In Tomcat 5.5/conf/server.xml, add:

。

In Tomcat 5.5/webapps/test/WEB-INF/web.xml add:

MySQL Connection Pool

JDBC for MySQL

javax.sql.DataSource

Container

In Tomcat 5.5/webapps/test/META-INF/context.xml:

4 test

Restart the Tomcat server and write test.jsp:

"http://www.w3.org/TR/REC-html40/strict.dtd";>

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.