TOMCAT5.0及TOMCAT5.5以上数据源配置不同写法

在配置JDND数据源的时候，要
5.0和5.5时要在安装目录\conf\Catalina\localhost目录下放置一个context.xml（名字自取，只要扩展名为.xml即可）文件
6.0时要在安装目录\conf目录下放置一个context.xml（名字自取，只要扩展名为.xml即可）文件


TOMCAT5.0配置写法：
<Context docBase="E:\workspace\jxkh\WebRoot" path="/jxkh" reloadable="true" workDir="work\Catalina\localhost\jxkh">
  <Resource name="jixiao" type="javax.sql.DataSource"/>
  <Resource name="jdbc/MsServerDB" type="javax.sql.DataSource"/>
  <Resource name="jixiaoView" type="javax.sql.DataSource"/>
  <ResourceParams name="jixiao">
    <parameter>
      <name>maxWait</name>
      <value>5000</value>
    </parameter>
    <parameter>
      <name>maxActive</name>
      <value>8</value>
    </parameter>
    <parameter>
      <name>password</name>
      <value>beizao</value>
    </parameter>
    <parameter>
      <name>url</name>
      <value>jdbc:microsoft:sqlserver://192.168.1.222:1433;DatabaseName=jxkh</value>
      <!--<value>jdbc:microsoft:sqlserver://192.168.1.220:1433;DatabaseName=jxkh</value>-->
      <!--<value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jxkh</value>-->
    </parameter>
    <parameter>
      <name>driverClassName</name>
      <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>8</value>
    </parameter>
    <parameter>
      <name>username</name>
      <value>beizao</value>
    </parameter>
  </ResourceParams>
 
    <ResourceParams name="jdbc/MsServerDB">
    <parameter>
      <name>maxWait</name>
      <value>5000</value>
    </parameter>
    <parameter>
      <name>maxActive</name>
      <value>8</value>
    </parameter>
    <parameter>
      <name>password</name>
      <value>beizao</value>
    </parameter>
    <parameter>
      <name>url</name>
      <value>jdbc:microsoft:sqlserver://192.168.1.222:1433;DatabaseName=jxkh</value>
      <!--<value>jdbc:microsoft:sqlserver://192.168.1.220:1433;DatabaseName=jxkh</value>-->
      <!--<value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jxkh</value>-->
    </parameter>
    <parameter>
      <name>driverClassName</name>
      <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>8</value>
    </parameter>
    <parameter>
      <name>username</name>
      <value>beizao</value>
    </parameter>
  </ResourceParams>


     <ResourceParams name="jixiaoView">
    <parameter>
      <name>maxWait</name>
      <value>5000</value>
    </parameter>
    <parameter>
      <name>maxActive</name>
      <value>40</value>
    </parameter>
    <parameter>
      <name>password</name>
      <value>userloginpass</value>
    </parameter>
    <parameter>
      <name>url</name>
      <value>jdbc:oracle:thin:@10.84.253.252:1521:ORCL</value>
    </parameter>
    <parameter>
      <name>driverClassName</name>
      <value>oracle.jdbc.driver.OracleDriver</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>2</value>
    </parameter>
    <parameter>
      <name>username</name>
      <value>otheruser</value>
    </parameter>
  </ResourceParams>
   
</Context>

TOMCAT5.5及以上配置写法：
<?xml version='1.0' encoding='utf-8'?>
<Context docBase="E:\workspace\ddscxt081007\WebRoot" path="/scxt" workDir="work\Catalina\localhost\scxt" reloadable="true">

<Resource  name="JDBC"
auth="Container"
type="javax.sql.DataSource"
maxWait="50" maxActive="20"
password="xjerp"
url="jdbc:oracle:thin:@192.168.1.222:1521:scxtdd"
driverClassName="oracle.jdbc.driver.OracleDriver"
maxIdle="2"
username="xjerp"/>

<Resource  name="SYSMANA"
auth="Container"
type="javax.sql.DataSource"
maxWait="50" maxActive="20"
password="sysmana"
url="jdbc:oracle:thin:@192.168.1.222:1521:scxtdd"
driverClassName="oracle.jdbc.driver.OracleDriver"
maxIdle="2"
username="sysmana"/>

<ResourceLink global="JDBC" name="JDBC" type="javax.sql.DataSource"/>
</Context>