Hi,

I'm faced with a peculair problem. We have a application which connect to a Mainframe Db2 and gets back data. We have a COBOL SP written to fetch the dataset. The problem now is when we try to call a particular SP from the app, it fails with the following error...

com.ibm.db2.jcc.a.SqlException: THE VALUE OF INPUT HOST VARIABLE OR PARAMETER NUMBER CANNOT BE USED AS SPECIFIED BECAUSE OF ITS DATA TYPE

When we test the same stored procedure(SP) using a Junit test class the SP is executed successfully and data is returned. But when we copy the same code from the Unit test and call it from within the application we end up with the above said error. The only difference is we use Hibernate to get a connection to the database.

Can anybody point out what might be the problem??

Data type mapping?

yes. Data Mapping!!