SQL Server JDBC - Issue with JDBC driver for sql server 2005

Author

Issue with JDBC driver for sql server 2005

Janardhan Kotha

2006-03-16, 11:23 am

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. 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="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. 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)

If anyone has faced similar issue, I appreciate if you can share your
experience.

FYI : I am using sqljdbc.jar extracted from sqljdbc_1.0.809.102_enu.exe that
is downloaded from microsoft site.

Thanks,
Kotha.

Joe Weinstein

2006-03-16, 1:23 pm

Janardhan Kotha wrote:
> 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. 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="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. 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)
>
> If anyone has faced similar issue, I appreciate if you can share your
> experience.
>
> FYI : I am using sqljdbc.jar extracted from sqljdbc_1.0.809.102_enu.exe that
> is downloaded from microsoft site.
>
> Thanks,
> Kotha.

Hi. If you email me I may be able to help..
Joe Weinstein at BEA Systems
j
o
e
AT
b
e
a
DOT
c
o
m

Sponsored Links