各位谁在TOMCAT中做过连接池？？50分请教

Question

看看这个吧
http://dev.csdn.net/develop/article/19/19013.shtm

Answer 1

这是我tomcat的连接池配置（server.xml），稍微改动一下就行了
        <Logger className="org.apache.catalina.logger.FileLogger"
                 directory="logs"  prefix="localhost_log." suffix=".txt"
            timestamp="true"/>
                 <Context path="" docBase="newsystem" debug="1" reloadable="true">
          <Resource name="jdbc/InformixDB" auth="Container" type="javax.sql.DataSource"/>
          <ResourceParams name="jdbc/InformixDB">
          <parameter>
            <name>factory</name>
            <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
          </parameter>
          <parameter>
            <name>driverClassName</name>
            <value>com.informix.jdbc.IfxDriver</value>
          </parameter>
          <parameter>
            <name>url</name>
            <value>jdbc:informix-sqli://192.168.0.238:6666/register:informixserver=online_web</value>
          </parameter>
          <parameter>
            <name>username</name>
            <value>informix</value>
          </parameter>
          <parameter>
            <name>password</name>
            <value>informix123</value>
          </parameter>
          <parameter>
            <name>maxActive</name>
            <value>10</value>
          </parameter>
          <parameter>
            <name>maxIdle</name>
            <value>3</value>
          </parameter>
          <parameter>
            <name>maxWait</name>
            <value>10000</value>
          </parameter>
          <parameter>
            <name>removeAbandoned</name>
            <value>true</value>
          </parameter>
          </ResourceParams>
          </Context>

Answer 2

还可以加上
web.xml文件放在<web-app>之下<description>MySQL Test App</description>
  <resource-ref>
      <description>DB Connection</description>
      <res-ref-name>jdbc/mysql</res-ref-name><!--//jdbc是连接资源-->
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
  </resource-ref>