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>
页:
[1]