想在一个TOMCAT服务里配置多个数据库连接池为什么老是说找不到这个连接池，正确的应该如何配呀

Question

在server.xml里
每一个不同的webapp配置不同的设置,如下所示代码<!--
APTalk Demo for MySql 4.1
-->
<Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="true" debug="5" docBase="D:\WorkSpace\aptalk\" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/aptalk" privileged="true" reloadable="true" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper">
         <Logger className="org.apache.catalina.logger.FileLogger" debug="0" directory="logs" prefix="localhost_aptalk_log." suffix=".txt" timestamp="true" verbosity="1"/>
          <Resource auth="Container" name="jdbc/aptalkdb" scope="Shareable" type="javax.sql.DataSource"/>
          <ResourceParams name="jdbc/aptalkdb">
            <parameter>
              <name>factory</name>
              <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
            </parameter>
            <parameter>
              <name>driverClassName</name>
              <value>com.mysql.jdbc.Driver</value>
            </parameter>
            <parameter>
              <name>url</name>
              <value>jdbc:mysql://localhost/aptalkdb</value>
            </parameter>
            <parameter>
              <name>username</name>
              <value>root</value>
            </parameter>
            <parameter>
              <name>password</name>
              <value></value>
            </parameter>
            <parameter>
              <name>useUnicode</name>
              <value>true</value>
            </parameter>
            <parameter>
              <name>characterEncoding</name>
              <value>GBK</value>
            </parameter>
            <parameter>
              <name>maxWait</name>
              <value>1000</value>
            </parameter>
            <parameter>
              <name>maxActive</name>
              <value>3000</value>
            </parameter>
            <parameter>
              <name>maxIdle</name>
              <value>1500</value>
            </parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>30</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
          </ResourceParams>        </Context>
<!--
WAP Demo for MySql 4.1
-->
<Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="true" debug="5" docBase="D:\WorkSpace\wapdemo\" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/wapdemo" privileged="true" reloadable="true" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper">
         <Logger className="org.apache.catalina.logger.FileLogger" debug="0" directory="logs" prefix="localhost_wapdemo_log." suffix=".txt" timestamp="true" verbosity="1"/>
          <Resource auth="Container" name="jdbc/test" scope="Shareable" type="javax.sql.DataSource"/>
          <ResourceParams name="jdbc/test">
            <parameter>
              <name>factory</name>
              <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
            </parameter>
            <parameter>
              <name>driverClassName</name>
              <value>com.mysql.jdbc.Driver</value>
            </parameter>
            <parameter>
              <name>url</name>
              <value>jdbc:mysql://localhost/test</value>
            </parameter>
            <parameter>
              <name>username</name>
              <value>root</value>
            </parameter>
            <parameter>
              <name>password</name>
              <value></value>
            </parameter>
            <parameter>
              <name>useUnicode</name>
              <value>true</value>
            </parameter>
            <parameter>
              <name>characterEncoding</name>
              <value>GBK</value>
            </parameter>
            <parameter>
              <name>maxWait</name>
              <value>1000</value>
            </parameter>
            <parameter>
              <name>maxActive</name>
              <value>3000</value>
            </parameter>
            <parameter>
              <name>maxIdle</name>
              <value>1500</value>
            </parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>60</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
          </ResourceParams>
        </Context>

Answer 1

可以到http://localhost:8080/admin下去配置,都是图型化的,应该没问题吧,呵呵
接分~~~`

Answer 2

只配置一个能正常运行吗?
web.xml配置了没有..

Answer 3

如果要是Tomcat5.0的话,也可以在Tomcat 5.0\conf\Catalina\localhost\下新建一个xml文件,然后在里面<?xml version='1.0' encoding='utf-8'?>
<Context docBase="D:\Tomcat 5.0\webapps\test" path="/test">
  <Resource name="jdbc/test" type="javax.sql.DataSource" auth="Container"/>
  <ResourceParams name="jdbc/test">
    <parameter>
      <name>url</name>
      <value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testserver</value>
    </parameter>
    <parameter>
      <name>username</name>
      <value>test</value>
    </parameter>
    <parameter>
      <name>password</name>
      <value>test</value>
    </parameter>
    <parameter>
      <name>driverClassName</name>
      <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
    </parameter>
    <parameter>
      <name>maxWait</name>
      <value>1000</value>
    </parameter>
    <parameter>
      <name>maxActive</name>
      <value>10000</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>10</value>
    </parameter>
  </ResourceParams>
</Context>然后在程序里编写代码截取如下:
        Connection conn = null;
        try {
            Context initContext = new InitialContext();
            Context envContext = (Context) initContext.lookup("java:/comp/env");
            DataSource ds = (DataSource) envContext.lookup("jdbc/test");
            conn = ds.getConnection();
        } catch (NamingException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return conn;在web.xml中加入    <resource-ref>
        <res-ref-name>jdbc/test</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
    </resource-ref>