Problem accessing DB2 from Universal Driver
In our application we use DB2 v 7 for z/os. We are using CLI based driver for accessing our data by using DB2 COBOL SPs.
We are migrating from CLI based version to Universal JDBC Driver and using Websphere App Server 6.0.
We are getting the errors like following while we fire SPs that have date, int or decimal or NULL parameters...
com.ibm.db2.jcc.a.SqlException: THE VALUE OF INPUT HOST VARIABLE OR PARAMETER NUMBER 010 CANNOT BE USED AS SPECIFIED BECAUSE OF ITS DATA TYPE
The code looks something like this...
if (startDate != null)
callableStatement.setDate(++i, new java.sql.Date(startDate.getTime()));
callableStatement.setDate(++i, null); //START-DA
if (standardAgmNo == null)
callableStatement.setNull(++i, Types.INTEGER); //AGM-NO
The same code has been working fine when we use CLI Driver and in production since last 3 years.
This is the version info for driver...
JDBC driver name : IBM DB2 JDBC Universal Driver Architecture
JDBC driver version : 2.7.58
JDBC driver type : 4
Can you kindly help us resolving this problem?
Thanks in advance.