1)下載mm.MySQL-2.0.14-bin.jar包,放在tomcat目錄下的common/lib文件夾中
2)在tomcat目錄下的conf/server.XML中的</Host>前加入(注意:全部大寫的地方要替換成你自己的東西)
以下為引用的內容:
<!--for MySQL database connection pool--><Context path="/APPLICATION_NAME" docBase="APPLICATIOIN_NAME" debug="5" reloadable="true" crossContext="true"> <Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_DBTest_log." suffix=".txt" timestamp="true"/> <Resource name="jdbc/DATABASE_NAME" auth="Container" type="Javax.sql.DataSource"/> <ResourceParams name="jdbc/DATABASE_NAME"> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <!-- Class name for mm.mysql JDBC driver --> <parameter> <name>driverClassName</name> <value>org.gjt.mm.mysql.Driver</value> </parameter> <!-- The JDBC connection url for connecting to your MySQL dB. The autoReconnect=true argument to the url makes sure that the mm.mysql JDBC Driver will automatically reconnect if mysqld closed the connection. mysqld by default closes idle connections after 8 hours.--> <parameter> <name>url</name> <value>jdbc:mysql://localhost:3306/DATABASE_NAME?autoReconnect=true</value> </parameter> <!-- MySQL dB username and password for dB connections --> <parameter> <name>username</name> <value>DB_USERNAME</value> </parameter> <parameter> <name>password</name> <value>DB_PASSWord</value> </parameter> <!-- Maximum number of dB connections in pool. Make sure you configure your MySQLd max_connections large enough to handle all of your db connections. Set to 0 for no limit.--> <parameter> <name>maxActive</name> <value>100</value>