Meaningless Drivel is fun!*
The moose likes Websphere and the fly likes Connection Error WSAD to SQL Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "Connection Error WSAD to SQL Server" Watch "Connection Error WSAD to SQL Server" New topic
Author

Connection Error WSAD to SQL Server

Guy Barden
Greenhorn

Joined: Jan 09, 2003
Posts: 5
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connection Error WSAD to SQL Server
 
Similar Threads
Am I doing anything wrong while setting up SQLServerDataSource.....
Connecting to Oracle data source from EJB
Please help setting up with MSSQL DataSource.
wsad 4.03 selectMethod=????
Error while trying to get the datasource object using JNDI lookup in WSAD....