tomcat4.1怎么配置多个数据库连接池啊???:(

Question

是不是不同datasource就是不同的池啊???

Answer 1

struts下的配置很简单，可以直接配：
<data-sources >
       <data-source key="DB1">
       <set-property 略/>
       </data-source>
       <data-source key="DB2">
       
       </data-source>
       <data-source key="DB3">
       
       </data-source>
  </data-sources>action调用：dataSource = getDataSource(request,"DB2");--------------------------
tomcat 下在server.xml里配置，如：
<Context crossContext="true" displayName="webproject" docBase="e:\tomcat5\webapps\webproject" path="/work" reloadable="true">
   <Resource name="mssql" type="javax.sql.DataSource"/>
  <ResourceParams name="mssql">
    <parameter>
      <name>url</name>
      <value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mssqlDB</value>
    </parameter>
    
    <parameter>
                                    
          <name>factory</name>
                                    
          <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
                             
            </parameter>
    <parameter>
      <name>password</name>
      <value>123456</value>
    </parameter>
    <parameter>
      <name>maxActive</name>
      <value>15</value>
    </parameter>
    <parameter>
      <name>maxWait</name>
      <value>5000</value>
    </parameter>
 
    <parameter>
      <name>driverClassName</name>
      <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
    </parameter>
    <parameter>
      <name>username</name>
      <value>dba1</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>2</value>
    </parameter>
  </ResourceParams>
  <Resource name="myora" type="javax.sql.DataSource"/>
  <ResourceParams name="myora">
    <parameter>
      <name>url</name>
      <value>jdbc:oracle:thin:@localhost:1521:oraDB</value>
    </parameter>
    
    <parameter>
                                    
          <name>factory</name>
                                    
          <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
                             
            </parameter>
    <parameter>
      <name>password</name>
      <value>123456</value>
    </parameter>
    <parameter>
      <name>maxActive</name>
      <value>15</value>
    </parameter>
    <parameter>
      <name>maxWait</name>
      <value>5000</value>
    </parameter>
 
    <parameter>
      <name>driverClassName</name>
      <value>oracle.jdbc.driver.OracleDriver</value>
    </parameter>
    <parameter>
      <name>username</name>
      <value>dba2</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>2</value>
    </parameter>
  </ResourceParams>
</Context>