Tomcat连接池首次配置问题

Question

还须在web.xml中配置数据库，连接池大小，等

Answer 1

server.xml全文
<Server port="8005" shutdown="SHUTDOWN" debug="0">
  <Service name="ServiceDefineByRiver">
    <Connector port="9001" minProcessors="5" maxProcessors="75"
     enableLookups="true" redirectPort="8443" acceptCount="10" debug="0" connectionTimeout="-1"/>
    <Engine name="EngineDefineByRiver" defaultHost="localhost" debug="0">
      <Host name="localhost" debug="0" appBase="F:\Site_River" 
       unpackWARs="true" autoDeploy="true">
        <Context path="" docBase="" debug="0"
                 reloadable="true" crossContext="true">
          <Logger className="org.apache.catalina.logger.FileLogger" directory="LogDefineByDigitalTitan" prefix="LogDefineByDigitalTitan." suffix=".txt"
           timestamp="true"/>
        </Context>
      </Host>
    </Engine>
  </Service>
  <Service name="ServiceDefineByColligateStatistic">
    <Connector port="9002" minProcessors="5" maxProcessors="75"
     enableLookups="true" redirectPort="8443" acceptCount="10" debug="0" connectionTimeout="-1" URIEncoding="gb2312"/>
    <Engine name="EngineDefineByColligateStatistic" defaultHost="localhost" debug="0">
      <Host name="localhost" debug="0" appBase="F:\Site_ColligateStatistic" 
       unpackWARs="true" autoDeploy="true">
        <Context path="" docBase="" debug="0"
                 reloadable="true" crossContext="true">
          <Logger className="org.apache.catalina.logger.FileLogger" directory="LogDefineByDigitalTitan" prefix="LogDefineByDigitalTitan." suffix=".txt"
           timestamp="true"/>
        </Context>
      </Host>
    </Engine>
  </Service>
<Service name="PlanManagement">
  <Connector port="9003" minProcessors="5" maxProcessors="75"
               enableLookups="true" redirectPort="8443"
               acceptCount="10" debug="0" connectionTimeout="-1"/>
    <Engine name="PlanManagement" defaultHost="planmanagement" debug="0">
      <Host name="planmanagement" debug="0" appBase="F:\PlanManagement" unpackWARs="true">
        <Context path="" docBase="F:\PlanManagement" debug="0">
          <Logger className="org.apache.catalina.logger.FileLogger" directory="LogDefineByDigitalTitan" prefix="LogDefineByDigitalTitan." suffix=".txt"
           timestamp="true"/>
          <Resource name="jdbc/OracleDB" auth="Container" type="javax.sql.DataSource"/>
          <ResourceParams name="jdbc/OracleDB">
                             
            <parameter>
                                    
              <name>factory</name>
                                    
              <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
                             
            </parameter>
                             
            <parameter>
                                    
              <name>driverClassName</name>
                                    
              <value>oracle.jdbc.driver.OracleDriver</value>
                             
            </parameter>
                             
            <parameter>
                                    
              <name>url</name>
                                    
              <value>jdbc:oracle:thin:@10.70.38.200:1521:orcl</value>
                             
            </parameter>
                             
            <parameter>
                                    
              <name>username</name>
                                    
              <value>java</value>
                             
            </parameter>
                             
            <parameter>
                                    
              <name>password</name>
                                    
              <value>java</value>
                             
            </parameter>
                             
            <parameter>
                                    
              <name>maxActive</name>
                                    
              <value>100</value>
                             
            </parameter>
                             
            <parameter>
                                    
              <name>maxIdle</name>
                                    
              <value>98</value>
                             
            </parameter>
                             
            <parameter>
                                    
              <name>maxWait</name>
                                    
              <value>-1</value>
                             
            </parameter>
                             
          </ResourceParams>
        </Context>
      </Host>
    </Engine>
  </Service>
</Server>

Answer 2

    环境配置没问题
    .jar文件也没问题
两个注意点：
          1.在sql server2000手动建库 如aaa
          2.把程序放入webapp下 并配置 conf 下的server.xml文件
如：（可以copy下边配置，相应修改就可以了，注意url，username，password是否正确）<Context path="/aaa" docBase="aaa" debug="0"   reloadable="true" crossContext="true"> 
   <Resource name="jdbc/aaa" auth="Container" type="javax.sql.DataSource"/>   
   <ResourceParams name="jdbc/aaa">
      <parameter>
          <name>factory</name>
      <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
        </parameter>
      <parameter>
         <name>driverClassName</name>
           <value>net.sourceforge.jtds.jdbc.Driver</value>
       </parameter>
        <parameter>
             <name>url</name>
             <value>jdbc:jtds:sqlserver://192.168.0.19:1433/aaa</value>   
         </parameter>
       <parameter>
            <name>username</name>
           <value>sa</value>
       </parameter>
      <parameter>
        <name>password</name>
        <value>sa</value>
          </parameter>
      <parameter>
    <name>maxActive</name>
    <value>20</value>
  </parameter>
         <parameter>
       <name>maxIdle</name>
          <value>10</value>
  </parameter>
         <parameter>
        <name>maxWait</name>
  <value>-1</value>
         </parameter>
        </ResourceParams>   
</Context>

Answer 3

为什么我配的连接池作压力测试时Tomcat死掉了，平均一天死一次，不用连接池没事。