wood burning stoves 2.0*
The moose likes JDBC and the fly likes Issue with JDBC driver for sql server 2005 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Issue with JDBC driver for sql server 2005" Watch "Issue with JDBC driver for sql server 2005" New topic
Author

Issue with JDBC driver for sql server 2005

Janardhan Kotha
Greenhorn

Joined: Feb 01, 2006
Posts: 14
All,

I am using jdbc driver for sql server 2005 on weblogic/websphere, following is the configuration I am using.

driver class : com.microsoft.sqlserver.jdbc.SQLServerXADataSource
data source helper class name in WSAD/RAD : com.ibm.websphere.rsadapter.ConnectJDBCDataStoreHelper

<property name="databaseName" value="pidbprod" />
<property name="serverName" value="pennsylvania" />
<property name="portNumber" value="1433" />
<property name="loginTimeout" value="" />
<property name="description" value="" />
<property name="enable2Phase" value="true" />
<property name="enableMultithreadedAccessDetection" value="false" />
<property name="preTestSQLString" value="SELECT 1 FROM TABLE1" />
<property name="user" value="pitest" />
<property name="password" value="pitest" />

I am getting the following exception after I execute Callable statement
and trying to retrieve out param values like callableStatement.getInt()/callableStatement.getString()

java.lang.NullPointerException at
com.microsoft.sqlserver.jdbc.SQLServerCallableStatement.indexOutParams(Unknown Source)
com.microsoft.sqlserver.jdbc.SQLServerCallableStatement.getOutParameters(Unknown Source)
com.microsoft.sqlserver.jdbc.SQLServerCallableStatement.getterGetParam(Unknown Source)
com.microsoft.sqlserver.jdbc.SQLServerCallableStatement.getInt(Unknown Source)
com.ibm.ws.rsadapter.jdbc.WSJdbcCallableStatement.getInt(WSJdbcCallableStatement.java:390)

Looks like there is a bug in the Sql server driver from microsoft, but I am not sure.

If anyone has faced similar issue, I appreciate if you can share your experience?

Thanks,
Kotha.
 
wood burning stoves
 
subject: Issue with JDBC driver for sql server 2005
 
Similar Threads
How to replace Derby with MySQL Ant properties & CLASSPATH reference
Data Source
Spring Application Context exception: Cannot find the declaration of element 'beans'
Error connecting to MSSQL Server from Hibernate
Connection through Applet using SQLServer 2000 Driver for JDBC