配置sql server 2005:
驱动:sqljdbc_1.2.2828.100_enu.exe解压包里的sqljdbc.jar
<database>
<jndi-name>jdbc/test</jndi-name>
<driver type="[color=red]com.microsoft.sqlserver.jdbc.SQLServerDriver[/color]">
<url>[color=red]jdbc:sqlserver:[/color]//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="[color=red]net.sourceforge.jtds.jdbc.Driver[/color]">
<url>[color=red]jdbc:jtds:sqlserver[/color]://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>
驱动:sqljdbc_1.2.2828.100_enu.exe解压包里的sqljdbc.jar
<database>
<jndi-name>jdbc/test</jndi-name>
<driver type="[color=red]com.microsoft.sqlserver.jdbc.SQLServerDriver[/color]">
<url>[color=red]jdbc:sqlserver:[/color]//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="[color=red]net.sourceforge.jtds.jdbc.Driver[/color]">
<url>[color=red]jdbc:jtds:sqlserver[/color]://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>