JDBC Poolconnection for JDTS and MsSql
843854Jan 6 2004 — edited Jan 7 2004Im trying to set up a JDBC connection pool in the Sun Application server Admin Console for Jtds.
I managed to set this up for the MS JDBC driver with the following settings.
Put the mssqlserver.jar, msutil.jar and the msbase.jar files in the AS classpath.
Create a connection pool with the following settings.
Datasource Classname = com.microsoft.jdbcx.sqlserver.SQLServerDataSource
Properties added:
<Name>User = <Value>"user name"
<Name>Password = <Value>"password"
<Name>ServerName = <Value> "servername"
<Name> PortNumber = <Value> 1433
<Name> DatabaseName =<Value>"databasename"
<Name> SelectMethod =<Value> cursor
And this works. ( all other settings are untouched: Pool Settings, Connection Validation, Transaction Isolation)
For JTDS I use as the Datasource Classname = net.sourceforge.jtds.jdbcx.TdsDataSource
However I cannot figure out which properties need to be specified.
Does anyone have a clue???