Tomcat和MySQL的一个Server.xml

$CATALINA_HOME/conf/server.xml

<Context path="/DBTest" docBase="DBTest"        debug="5" reloadable="true" crossContext="true">  <Logger className="org.apache.catalina.logger.FileLogger"             PRefix="localhost_DBTest_log." suffix=".txt"             timestamp="true"/>  <Resource name="jdbc/TestDB"               auth="Container"               type="javax.sql.DataSource"/>  <ResourceParams name="jdbc/TestDB">    <parameter>      <name>factory</name>      <value>org.apache.commons.dbcp.BasicDataSourceFactory</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>    </parameter>    <!-- Maximum number of idle dB connections to retain in pool.         Set to -1 for no limit.  See also the DBCP documentation on this         and the minEvictableIdleTimeMillis configuration parameter.         -->    <parameter>      <name>maxIdle</name>      <value>30</value>    </parameter>    <!-- Maximum time to wait for a dB connection to become available         in ms, in this example 10 seconds. An Exception is thrown if         this timeout is exceeded.  Set to -1 to wait indefinitely.         -->    <parameter>      <name>maxWait</name>      <value>10000</value>    </parameter>    <!-- MySQL dB username and passWord for dB connections  -->    <parameter>     <name>username</name>     <value>javauser</value>    </parameter>    <parameter>     <name>password</name>     <value>javadude</value>    </parameter>    <!-- Class name for the old mm.mysql JDBC driver - uncomment this entry and comment next         if you want to use this driver - we recommend using Connector/J though    <parameter>       <name>driverClassName</name>       <value>org.gjt.mm.mysql.Driver</value>    </parameter>     -->        <!-- Class name for the official MySQL Connector/J driver -->    <parameter>       <name>driverClassName</name>       <value>com.mysql.jdbc.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/javatest?autoReconnect=true</value>    </parameter>  </ResourceParams></Context>