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>
还没有人抢沙发呢~