This content has been marked as final.
Show 1 reply
-
1. Re: setup datasource with MS sql server
keanthian Sep 21, 2004 9:46 AM (in response to gzhang107)copy msbase.jar,mssqlserver.jar,msutil.jar to your server//{server_config}/deploy/lib folder
your mssql-ds.xml should look like something like this
<?xml version="1.0" encoding="UTF-8"?>
<local-tx-datasource>
<jndi-name>YourJNDIName</jndi-name>
<connection-url>jdbc:microsoft:sqlserver://servername:1433;DatabaseName=DatabaseName</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<min-pool-size>100</min-pool-size>
<max-pool-size>1000</max-pool-size>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<user-name>x</user-name>
y
hope it helps