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

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


[color=red]TOMCAT5.0配置写法：[/color]
<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>

[color=red]TOMCAT5.5及以上配置写法：[/color]
<?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>