java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]JTA
is not support when selectMethod=direct. Switch to
selectMethod=cursor.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown
Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown
Source)
at com.microsoft.jdbcx.sqlserver.SQLServerDataSource.getXAConnection(Unknown
Source)
at com.ibm.ejs.cm.pool.JTAConnectionFactory.createConnection(JTAConnectionFactory.java:40)
at com.ibm.ejs.cm.pool.ConnectionPool.createConnection(ConnectionPool.java:891)
at com.ibm.ejs.cm.pool.ConnectionPool.createOrWaitForConnection(ConnectionPool.java:823)
at com.ibm.ejs.cm.pool.ConnectionPool.findFreeConnection(ConnectionPool.java:741)
at com.ibm.ejs.cm.pool.ConnectionPool.findConnectionForTx(ConnectionPool.java:660)
at com.ibm.ejs.cm.pool.ConnectionPool.allocateConnection(ConnectionPool.java:594)
at com.ibm.ejs.cm.pool.ConnectionPool.getConnection(ConnectionPool.java:272)
at com.ibm.ejs.cm.pool.ConnectionPool.getConnection(ConnectionPool.java:267)
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java:99)
I downloaded SQLServer 2000 Driver for JDBC from
http://www.microsoft.com/downloads/details.aspx?FamilyID=4f8f2f01-1ed7-4c4d-8f7b-3d47969e66ae&DisplayLang=en#filelist
FYI
Server Class Path :
D:\Downloads\jdbc\ms\mssqlserver\msjdbc\lib\msbase.jar;D:\Downloads\jdbc\ms\mssqlserver\msjdbc\lib\msutil.jar;D:\Downloads\jdbc\ms\mssqlserver\msjdbc\lib\mssqlserver.jar;
Implementation Classname:
com.microsoft.jdbcx.sqlserver.SQLServerDataSource
Data Sources
Name: MSSQLDataSource
JNDI Name: jdbc/MSSQLDataSource
Database Name: testdb
Default User ID: tomandjerry
Default Password: tomandjerry
Resource Properties
URL jdbc:microsoft:sqlserver://loclhost:1433;selectMethod=cursor;
Have I missed something?.
Thanks in advance.
Cheers!
Zayed