wood burning stoves*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "wsad 4.03 selectMethod=????" Watch "wsad 4.03 selectMethod=????" New topic
Author

wsad 4.03 selectMethod=????

dylan thomas
Greenhorn

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
Greenhorn

Joined: Apr 25, 2005
Posts: 1
I too face the same problem ? Can anyone help me ? Thanks
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: wsad 4.03 selectMethod=????
 
Similar Threads
Am I doing anything wrong while setting up SQLServerDataSource.....
Connection Error WSAD to SQL Server
Setting autoCommit(false)/Rollback()
Please help setting up with MSSQL DataSource.
Access Server's Datasource from standalone