数据源xml

server.xml

<Context path="/mos/bbs" reloadable="true" docBase="D:/Documents and Settings/Administrator/workspace/bbs/WebRoot" workDir="${catalina.home}/work" crossContext="true">
<Resource auth="Container" name="jdbc/mos" type="javax.sql.DataSource"
driverClassName="com.ibm.db2.jcc.DB2Driver"
maxIdle="12" maxWait="5000" username="db2admin" password="123456" url="jdbc:db2://localhost:50000/MOS" maxActive="14"/>
<Resource auth="Container" name="ResourceOne/DataSource" type="javax.sql.DataSource"
driverClassName="com.ibm.db2.jcc.DB2Driver"
maxIdle="2" maxWait="5000" username="db2admin" password="123456" url="jdbc:db2://localhost:50000/ROEEE" maxActive="100"/>
<Resource auth="Container" name="jdbc/ROEEE" type="javax.sql.DataSource"
driverClassName="com.ibm.db2.jcc.DB2Driver"
maxIdle="2" maxWait="5000" username="db2admin" password="123456" url="jdbc:db2://localhost:50000/ROEEE" maxActive="100"/>
</Context>

<!-- bbs2
<Context path="/bbs2" reloadable="true" docBase="D:/Documents and Settings/Administrator/workspace/bbs2/WebRoot" workDir="${catalina.home}/work" crossContext="true">
<Resource auth="Container" name="jdbc/mos" type="javax.sql.DataSource"
driverClassName="com.ibm.db2.jcc.DB2Driver"
maxIdle="12" maxWait="5000" username="db2admin" password="123456" url="jdbc:db2://localhost:50000/MOS" maxActive="14"/>
</Context>
-->



<!--bbs mysql
<Context path="/bbs" reloadable="true" docBase="D:/Documents and Settings/Administrator/workspace/bbs/WebRoot" workDir="${catalina.home}/work" crossContext="true">
<Resource auth="Container" name="jdbc/mos" type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
maxIdle="12" maxWait="5000" username="root" password="root" url="jdbc:mysql://localhost:3306/mos?useUnicode=true&characterEncoding=UTF-8" maxActive="14"/>
</Context>
-->

</Host>
//oracle 连接的配置
<Host>


<Context path="/GDS" reloadable="true" docBase="D:/Documents and Settings/Administrator/workspace/GDS/WebContent" workDir="${catalina.home}/work" crossContext="true">
<Resource name="jdbc/GDS" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@192.168.1.10:1521:GDS" username="gds" password="gds" maxActive="20" maxIdle="10" maxWait="-1"/>
</Context>

</Host>

Catalina\localhost


<?xml version='1.0' encoding='utf-8'?>
<Context docBase="bbs" path="/mos/bbs" workDir="work\Catalina\localhost\bbs">
<Resource name="jdbc/MOS" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/MOS">
<parameter>
<name>url</name>
<value>jdbc:db2://192.168.1.166:50000/MOS</value>
</parameter>
<parameter>
<name>password</name>
<value>123456</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.ibm.db2.jcc.DB2Driver</value>
</parameter>
<parameter>
<name>username</name>
<value>db2admin</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
</ResourceParams>
</Context>

//oracle 连接的配置
<?xml version="1.0" encoding="UTF-8"?>
<Context docBase="GDS" path="/GDS" workDir="work\Catalina\localhost\GDS">
<Resource name="jdbc/GDS" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/GDS">
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>password</name>
<value>gds</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@192.168.1.9:1521:GDS</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>username</name>
<value>gds</value>
</parameter>
</ResourceParams>
</Context>