数据源xml

javawjy

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>