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.
By Thomas in forum ASP.NET
Last Post: 11-10-2009, 02:31 PM
Last Post: 09-18-2002, 01:25 PM
By Melquisedeque in forum ASP.NET
Last Post: 02-07-2002, 07:21 AM
By Victor in forum ASP.NET
Last Post: 02-07-2001, 10:05 AM
Last Post: 02-01-2001, 02:32 AM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL