resin配置jndi方式连接sql server 2005和2000

配置sql server 2005:
驱动:sqljdbc_1.2.2828.100_enu.exe解压包里的sqljdbc.jar
         <database>
           <jndi-name>jdbc/test</jndi-name>
           <driver type="com.microsoft.sqlserver.jdbc.SQLServerDriver">
             <url>jdbc:sqlserver://127.0.0.1:1433;selectmethod=cursor</url>
             <user>sa</user>
             <password>sa</password>
            </driver>
            <prepared-statement-cache-size>8</prepared-statement-cache-size>
            <max-connections>500</max-connections>
            <max-idle-time>30s</max-idle-time>
          </database>



配置sql server 2000:
驱动:jtds-1.2.jar
         <database>
           <jndi-name>jdbc/test</jndi-name>
           <driver type="net.sourceforge.jtds.jdbc.Driver">
             <url>jdbc:jtds:sqlserver://localhost:1433;selectmethod=cursor</url>
             <user>sa</user>
             <password>sa</password>
            </driver>
            <prepared-statement-cache-size>8</prepared-statement-cache-size>
            <max-connections>500</max-connections>
            <max-idle-time>30s</max-idle-time>
          </database>