Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    190

    Unanswered: IBM Type 4 Driver Issue

    Has anyone seen anything similiar to the issue below ?

    We are trying to retrieve result sets from DB2 Stored Procs. When we use IBM's Type 2 driver, we are successful. But, when we try to use IBM's Type 4 driver, the CallableStatement.execute() returns "false" indicating that no results were returned. The code we are using is identical between the Type 2 and the Type 4 driver.

    Using SQL statements, we can get result sets without issue. Our only problem is with the stored procs.

    DB21085I Instance "db2inst3" uses "64" bits and DB2 code release "SQL08028"
    with level identifier "03090106".
    Informational tokens are "DB2 v8.1.0.136", "s070720", "U810953", and FixPak
    "15".
    Product is installed at "/opt/IBM/db2/V8.1".

  2. #2
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    You are n't getting any SQL error-code or error-mesg with TYPE-4 apart from the issue that no-results are returned.

    Please see the following link which can be helpful for you:

    http://www.ibm.com/developerworks/db...dm-0512kokkat/

    Thanks,
    Jayanta

Posting Permissions

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