Tomcat 5.x 连接池配置

 

  <!-- Tomcat 5.x 连接池配置，将下面这段xml粘帖到Tomcat 安装目录下conf文件中server.xml <Host>中  Demov2是你要配置项目名称-->
			<Context path="/Demov2" docBase="D:\bpcrm\Tomcat50\webapps\Demov2">
  			<Resource name="jdbc/Demov2" scope="Shareable" type="javax.sql.DataSource"/>
  				<ResourceParams name="jdbc/Demov2">
    			<parameter>
     			 <name>factory</name>
      			<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
    			</parameter>
    <!-- DBCP database connection settings -->
   				 <parameter>
      			<name>url</name>
     				 <value>jdbc:mysql://127.0.0.1:3306/blank?characterEncoding=utf8</value>
    				</parameter>
    			<parameter>
      <name>driverClassName</name>
      <value>com.mysql.jdbc.Driver</value>
    </parameter>
    <parameter>
      <name>username</name>
      <value>root</value>
    </parameter>
    <parameter>
      <name>password</name>
      <value>bpcrm</value>
    </parameter>
    <!-- DBCP connection pooling options -->
    <parameter>
      <name>maxWait</name>
      <value>3000</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>100000</value>
    </parameter>
    <parameter>
      <name>maxActive</name>
      <value>100</value>
    </parameter>
  </ResourceParams>
</Context>