SQL Server JDBC - NullPointerException in CallableStatement of Sql server 2005 drive

Author

NullPointerException in CallableStatement of Sql server 2005 drive

Kotha

2006-03-21, 1:24 pm

Hi,

I am getting the following null pointer with sql server 2005 driver.

java.lang. NullPointerException
at
com.microsoft.sqlserver.jdbc. SQLServerCallableSta
tement. indexOutParams(Unkno
wn Source)
com.microsoft.sqlserver.jdbc. SQLServerCallableSta
tement. getOutParameters(Unk
nown Source)
com.microsoft.sqlserver.jdbc. SQLServerCallableSta
tement. getterGetParam(Unkno
wn Source)
com.microsoft.sqlserver.jdbc. SQLServerCallableSta
tement.getInt(Unknown Source)
com.ibm.ws.rsadapter.jdbc. WSJdbcCallableStatem
ent. getInt(WSJdbcCallabl
eStatement.java:390)
com.xyz.dao.mssql.SearchDAO. searchItems(SearchDA
O.java:718)
com.xyz.dao.mssql.SearchDAO. searchItems(SearchDA
O.java:516)
com.xyz.ejb.finder.FinderEJBBean. searchItems(FinderEJ
BBean.java:182)
com.xyz.ejb.finder. EJSLocalStatelessFin
derEJB_a98aa111. searchItems(EJSLocal
StatelessFinderEJB_a
98aa111.java:183)
com.xyz.ejb.workflow.WorkFlowEJBBean. searchItems(WorkFlow
EJBBean.java:3087)
com.xyz.ejb.workflow. EJSRemoteStatelessWo
rkFlowEJB_36f544ce. searchItems(EJSRemot
eStatelessWorkFlowEJ
B_36f544ce.java:2624)
com.xyz.ejb.workflow. _WorkFlowEJBRemote_S
tub. searchItems(_WorkFlo
wEJBRemote_Stub.java:2825)
com.xyz.web.delegate. BusinessDelegateImpl
. searchItems(Business
DelegateImpl.java:356)
com.xyz.web.actions.Action.newSearch(Action.java:3005)

My code is as follows.
int value = call.getInt(30); // EXCEPTION is coming here.

Configuration of my application :
I am using jdbc driver for sql server 2005 on weblogic/websphere

driver class : com.microsoft.sqlserver.jdbc. SQLServerXADataSourc
e
data source helper class name in WSAD/RAD :
com.ibm.websphere.rsadapter. ConnectJDBCDataStore
Helper

Data source properties are as follows:

<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=" enableMultithreadedA
ccessDetection" value="false" />
<property name="preTestSQLString" value="SELECT 1 FROM TABLE1" />
<property name="user" value="*******" />
<property name="password" value="*******" />

FYI : I am using sqljdbc.jar extracted from sqljdbc_1.0.809.102_enu.exe that
is downloaded from microsoft site. This code is working absolutely fine with
Sql Server 2000.

I HOPE SOMEONE FROM MICROSOFT WILL HELP ME WITH THIS.

Thanks,
Kotha.

HERLANI JUNIOR

2006-03-21, 1:24 pm

Kotha,

Are you sure, that the call are you doing has 30 output parameters ?

Look the exception:
com.microsoft.sqlserver.jdbc. SQLServerCallableSta
tement.indexOutParams

Rgds,

"Kotha" wrote:

> Hi,
>
> I am getting the following null pointer with sql server 2005 driver.
>
> java.lang. NullPointerException
at
> com.microsoft.sqlserver.jdbc. SQLServerCallableSta
tement. indexOutParams(Unkno
wn Source)
> com.microsoft.sqlserver.jdbc. SQLServerCallableSta
tement. getOutParameters(Unk
nown Source)
> com.microsoft.sqlserver.jdbc. SQLServerCallableSta
tement. getterGetParam(Unkno
wn Source)
> com.microsoft.sqlserver.jdbc. SQLServerCallableSta
tement.getInt(Unknown Source)
> com.ibm.ws.rsadapter.jdbc. WSJdbcCallableStatem
ent. getInt(WSJdbcCallabl
eStatement.java:390)
> com.xyz.dao.mssql.SearchDAO. searchItems(SearchDA
O.java:718)
> com.xyz.dao.mssql.SearchDAO. searchItems(SearchDA
O.java:516)
> com.xyz.ejb.finder.FinderEJBBean. searchItems(FinderEJ
BBean.java:182)
> com.xyz.ejb.finder. EJSLocalStatelessFin
derEJB_a98aa111. searchItems(EJSLocal
StatelessFinderEJB_a
98aa111.java:183)
> com.xyz.ejb.workflow.WorkFlowEJBBean. searchItems(WorkFlow
EJBBean.java:3087)
> com.xyz.ejb.workflow. EJSRemoteStatelessWo
rkFlowEJB_36f544ce. searchItems(EJSRemot
eStatelessWorkFlowEJ
B_36f544ce.java:2624)
> com.xyz.ejb.workflow. _WorkFlowEJBRemote_S
tub. searchItems(_WorkFlo
wEJBRemote_Stub.java:2825)
> com.xyz.web.delegate. BusinessDelegateImpl
. searchItems(Business
DelegateImpl.java:356)
> com.xyz.web.actions.Action.newSearch(Action.java:3005)
>
> My code is as follows.
> int value = call.getInt(30); // EXCEPTION is coming here.
>
> Configuration of my application :
> I am using jdbc driver for sql server 2005 on weblogic/websphere
>
> driver class : com.microsoft.sqlserver.jdbc. SQLServerXADataSourc
e
> data source helper class name in WSAD/RAD :
> com.ibm.websphere.rsadapter. ConnectJDBCDataStore
Helper
>
> Data source properties are as follows:
>
> <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=" enableMultithreadedA
ccessDetection" value="false" />
> <property name="preTestSQLString" value="SELECT 1 FROM TABLE1" />
> <property name="user" value="*******" />
> <property name="password" value="*******" />
>
> FYI : I am using sqljdbc.jar extracted from sqljdbc_1.0.809.102_enu.exe that
> is downloaded from microsoft site. This code is working absolutely fine with
> Sql Server 2000.
>
> I HOPE SOMEONE FROM MICROSOFT WILL HELP ME WITH THIS.
>
> Thanks,
> Kotha.

Sponsored Links