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

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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

Issue with JDBC driver for sql server 2005

Janardhan Kotha

Joined: Feb 01, 2006
Posts: 14

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?

I agree. Here's the link: http://aspose.com/file-tools
subject: Issue with JDBC driver for sql server 2005
Similar Threads
Connection through Applet using SQLServer 2000 Driver for JDBC
Data Source
How to replace Derby with MySQL Ant properties & CLASSPATH reference
Spring Application Context exception: Cannot find the declaration of element 'beans'
Error connecting to MSSQL Server from Hibernate