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".

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