成功配置環境Tomcat5.0.28+MSSQLServer2000+MS JDBC Driver

一、    安裝Tomcat5.0.28

二、    安裝MS JDBC Driver
假設安裝路徑是F:/green/Microsoft SQL Server 2000 JDBC，那么在F:/green/Microsoft SQL Server 2000 JDBC/lib下面有三個文件msbase.jar、sqlserver.jar、msutil.jar,并將此三個文件復制到%TOMMCAT_HOME%/common/lib目錄下

三、    注冊JNDI數據源
修改%TOMCAT_HOME%/conf/Catalina/localhost/目錄下您的應用程序對應的配置文件
如：我的一個應用WebDemo.xml文件如下：
<?xml version='1.0' encoding='utf-8'?>
<Context workDir="work/Catalina/localhost/WebDemo" path="/WebDemo" docBase="D:/jakarta-tomcat-5.0.28/webapps/WebDemo">
    <Resource type="javax.sql.DataSource"  auth="Container"  name="jdbc/northwind"/>  
    <ResourceParams name="jdbc/northwind">
      <parameter>
        <name>maxWait</name>
        <value>5000</value>
      </parameter>
      <parameter>
        <name>maxActive</name>
        <value>4</value>
      </parameter>
      <parameter>
        <name>passWord</name>
        <value>jckjdkmcj</value>
      </parameter>
      <parameter>
        <name>url</name>
        <value>jdbc:microsoft:sqlserver://10.0.0.168:1433;databaseName=northwind</value>
      </parameter>
      <parameter>
        <name>driverClassName</name>
        <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
      </parameter>
      <parameter>
        <name>maxIdle</name>
        <value>2</value>
      </parameter>
      <parameter>
        <name>username</name>
        <value>sa</value>
      </parameter>
    </ResourceParams>
   <Resource type="javax.sql.DataSource" name="jdbc/zydb"/>
    <ResourceParams name="jdbc/zydb">
      <parameter>
        <name>url</name>
        <value>jdbc:Oracle:thin:@10.0.0.168:1521:ZYDB</value>
      </parameter>
      <parameter>
        <name>password</name>
        <value>jckjdkmcj</value>
      </parameter>
      <parameter>
        <name>maxActive</name>
        <value>4</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>zhangyi</value>
      </parameter>
      <parameter>
        <name>maxIdle</name>
        <value>2</value>
      </parameter>
    </ResourceParams>
</Context>