在server.xml 中:
在一个WEB APPLICATION中配置两个数据源.mssql和myora
<Context crossContext="true" displayName="work" docBase="D:/java/work/query" path="/work" reloadable="true">
   <Resource name="mssql" type="javax.sql.DataSource"/>
  <ResourceParams name="mssql">    <parameter>
      <name>url</name>
      <value>jdbc:microsoft:sqlserver://Sibm5:1433;DatabaseName=FixPlan</value>
    </parameter>
    
    <parameter>
                                    
          <name>factory</name>
                                    
          <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
                             
            </parameter>
    <parameter>
      <name>password</name>
      <value>ouery</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>query</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:@hmis.clc.com:1521:hmis</value>
    </parameter>
    
    <parameter>
                                    
          <name>factory</name>
                                    
          <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
                             
            </parameter>
    <parameter>
      <name>password</name>
      <value>cxxt</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>cxxt</value>
    </parameter>    <parameter>
      <name>maxIdle</name>
      <value>2</value>
    </parameter>  </ResourceParams>
</Context>