Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]JTA is not support when selectMethod=direct. Switch to selectMethod=cursor.

3 views
Skip to first unread message

zayed

unread,
Jun 11, 2003, 6:39:54 AM6/11/03
to
I get the following exception in my Websphere log while trying to
connect to the SQL Server 2000 database. I am unable to proceed
further. please help.

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

0 new messages