This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

wsad 4.03 selectMethod=????

 
dylan thomas
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I too face the same problem ? Can anyone help me ? Thanks
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic