File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connection Error WSAD to SQL Server

 
Guy Barden
Greenhorn
Posts: 5
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I am using the UTE in WSAD to test an EJB that I am developing. I have set up the Data Source information in the Server Configuration, using the com.microsoft.jdbcx.sqlserver.SQLServerDataSource driver class and defined a JNDI name for the datasource.
When I attempt to connect to the DB in EJB code with
InitialContext ic = new InitialContext();
DataSource ds = (DataSource)ds.lookup(jndiName);
Connection con = ds.getConnection();
I get an exception, and the following JDBC error
com.ibm.ejs.container.CreateFailureException: javax.ejb.EJBException: Unable to connect to database. [Microsoft][SQLServer 2000 Driver for JDBC]JTA is not support when selectMethod=direct. Switch to selectMethod=cursor.;
My question is, how do I set the JDBC connection property 'selectMethod' within the WSAD Server DataSource configuration. Or is this something I need to set within java code prior to obtaining a connection?
Thanks in advance
Guy
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic