• Post Reply Bookmark Topic Watch Topic
  • New Topic

Issue with JDBC driver for sql server 2005  RSS feed

Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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)

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?

  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!