[progress Communities] [progress Openedge Abl] Forum Post: Ibm Db2 Stored Procedure Calls

[Jason Goh]

Hi I'm doing a POC with the Progress DataDirect drivers for my organisation and am having trouble calling some of our legacy stored procedures in DB2 ( SYSIBM.VERSION = DSN10015 = DB2 for Z/OS 10.1 ) using the DataDirect jdbc drivers. java.sql.SQLNonTransientConnectionException: [DataDirect][DB2 JDBC Driver]No more data available to read. at com.ddtek.jdbc.db2base.ddcp.b(Unknown Source) at com.ddtek.jdbc.db2base.ddcp.a(Unknown Source) at com.ddtek.jdbc.db2base.ddco.b(Unknown Source) at com.ddtek.jdbc.db2base.ddco.a(Unknown Source) at com.ddtek.jdbc.db2base.ddco.a(Unknown Source) at com.ddtek.jdbc.db2.drda.ddp.a(Unknown Source) at com.ddtek.jdbc.db2.drda.ddr.a(Unknown Source) at com.ddtek.jdbc.db2.drda.ddj.a(Unknown Source) at com.ddtek.jdbc.db2.drda.ddp.b(Unknown Source) at com.ddtek.jdbc.db2.ddh.i(Unknown Source) at com.ddtek.jdbc.db2base.dde0.e(Unknown Source) at com.ddtek.jdbc.db2base.dde0.a(Unknown Source) at com.ddtek.jdbc.db2base.dddw.a(Unknown Source) at com.ddtek.jdbc.db2base.dde0.x(Unknown Source) at com.ddtek.jdbc.db2base.dde0.t(Unknown Source) at com.ddtek.jdbc.db2base.dddw.execute(Unknown Source) at com.ddtek.jdbcx.db2base.ddl.execute(Unknown Source) at com.experian.esb.db2.GenericDb2Progress.callProcedure(GenericDb2Progress.java:137) at com.experian.esb.db2.GenericDb2Progress.main(GenericDb2Progress.java:105) java.sql.SQLNonTransientConnectionException: [DataDirect][DB2 JDBC Driver]No more data available to read. at com.ddtek.jdbc.db2base.ddcp.b(Unknown Source) at com.ddtek.jdbc.db2base.ddcp.a(Unknown Source) at com.ddtek.jdbc.db2base.ddco.b(Unknown Source) at com.ddtek.jdbc.db2base.ddco.a(Unknown Source) at com.ddtek.jdbc.db2base.ddco.a(Unknown Source) at com.ddtek.jdbc.db2.drda.ddp.a(Unknown Source) at com.ddtek.jdbc.db2.drda.ddr.a(Unknown Source) at com.ddtek.jdbc.db2.drda.ddj.a(Unknown Source) at com.ddtek.jdbc.db2.drda.ddp.b(Unknown Source) at com.ddtek.jdbc.db2.ddh.i(Unknown Source) at com.ddtek.jdbc.db2base.dde0.e(Unknown Source) at com.ddtek.jdbc.db2base.dde0.a(Unknown Source) at com.ddtek.jdbc.db2base.dddw.a(Unknown Source) at com.ddtek.jdbc.db2base.dde0.x(Unknown Source) at com.ddtek.jdbc.db2base.dde0.t(Unknown Source) at com.ddtek.jdbc.db2base.dddw.execute(Unknown Source) Connection released at com.ddtek.jdbcx.db2base.ddl.execute(Unknown Source) at com.experian.esb.db2.GenericDb2Progress.callProcedure(GenericDb2Progress.java:137) at com.experian.esb.db2.GenericDb2Progress.main(GenericDb2Progress.java:105) It appears to affect stored procedures that return multiple ResultSets in a single call and if I switch over to the IBM type 4 driver the call works fine. Am I doing something silly or do we need to change something in the stored procedure definitions to gracefully handle multiple ResultSets/cursors? Suggestions would be much appreciated! Regards, Jason

Continue reading...