File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Websphere and the fly likes wsad 4.03 selectMethod=???? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "wsad 4.03 selectMethod=????" Watch "wsad 4.03 selectMethod=????" New topic

wsad 4.03 selectMethod=????

dylan thomas

Joined: Jul 23, 2003
Posts: 1
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???
Krishnamoorthi BM

Joined: Apr 25, 2005
Posts: 1
I too face the same problem ? Can anyone help me ? Thanks
I agree. Here's the link:
subject: wsad 4.03 selectMethod=????
jQuery in Action, 3rd edition