File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Issue with JDBC driver for sql server 2005