Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2005
    Posts
    5

    Unanswered: COBOL SP and Hibernate

    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??

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by karthikravi
    Can anybody point out what might be the problem??
    Data type mapping?
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Jul 2005
    Posts
    5
    yes. Data Mapping!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •