Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - SQL Server 2005/Yukon
 Issue with jdbc driver for sql server 2005

Author  Topic 

rao.kotha
Starting Member

1 Post

Posted - 2006-03-14 : 17:29:52
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 able to connect to login to the database but I am getting the following exception when I am using anything 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)

Please help me.
Thanks,
Kotha.
   

- Advertisement -