About Tomcat configuring multiple connection pools
If it's TOMCAT5.
Meta-inf under the Context.xml
Make a change to this paragraph
<resource
Name= "Jdbc/aa"
Type= "Javax.sql.DataSource"
Driverclassname= "Com.microsoft.jdbc.sqlserver.SQLServerDriver"
Password= "123456"
Maxidle= "10"
maxwait= "-1"
Username= "123"
Url= "Jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=aa"
Maxactive= "/>"
Add to the back of the original, you need to make appropriate changes to the parameters
If it's TOMCAT4.
Change conf under Server.xml
<context path= "/gdmail" reloadable= "false" docbase= "Gdmail" >
<!--This is the first connection pool-->
<resource name= "Jdbc/dsmail" auth= "Container" type= "Javax.sql.DataSource"/>
<resourceparams name= "Jdbc/dsmail" >
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<!--DBCP database connection Settings-->
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=GB2312</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>123456</value>
</parameter>
<!--DBCP connection pooling Options-->
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>36</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>36</value>
</parameter>
</ResourceParams>
<!--This is the second connection pool-->
<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>url</name>
<value>jdbc:oracle:thin:@192.168.0.10:1521:ering</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>username</name>
<value>admin</value>
</parameter>
<parameter>
<name>password</name>
<value>123456</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>1000</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
</ResourceParams>
<!--second connection pool end-->
</Context>