I'm trying to connect to sql 2000 using the MS driver.
When I run this code:
javax.naming.InitialContext ctx = new javax.naming.InitialContext();
javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup("jdbc/myname");
java.sql.Connection connection = ds.getConnection();
I get this error:
ConnectionPoo X CONM6009E: Failed to get connection to the database from datasource (DEVIPA2).
SystemOut U java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC]JTA is not support when selectMethod=direct. Switch to selectMethod=cursor.
Do I just need to configure the selectMethod property? I can't figure out how to do this with the Websphere Administrative Domain in WSAD....
Has anyone experienced this???
