Reading array result set with jdbc
In a SQLRPGLE program I am returning an array result set.
When reading this result set with the toolbox JDBC driver I have no
problems.
I want to read the result set with the native DB2 jdbc driver instead
of using the toolbox driver. This driver is giving me troubles. When
reading the result set I only get 1 row instead of the 30 that I am
expecting. What could be wrong ?
The server trace of the jdbc driver tells me:
[2-5-08 15:50:21:447 CEST] 00000024 SystemOut O as400: Callable
statement Not Displayed: Executed STMT00024 [CALL
PVC2DO.QP_V001(?, ?, ?, ?, ?, ?)].
[2-5-08 15:50:21:447 CEST] 00000024 SystemOut O as400: Callable
statement Not Displayed: Update count = -1.
[2-5-08 15:50:21:447 CEST] 00000024 SystemOut O as400: Callable
statement Not Displayed: Result set = true.
[2-5-08 15:50:21:447 CEST] 00000024 SystemOut O as400: Callable
statement Not Displayed: Number of result sets = -1.
[2-5-08 15:50:21:447 CEST] 00000024 SystemOut O as400: Callable
statement Not Displayed: Return Code = 20.
When reading the result set I only get 1 row instead of the 30 that I
am expecting.
The toolbox trace shows:
[2-5-08 14:06:25:840 CEST] 00000024 SystemOut O as400:
CallableStatement STMT0004 (1515870810) : Executed STMT0004*, SQL
Statement --> [CALL PVC2DO.QP_V001(?, ?, ?, ?, ?, ?)].
[2-5-08 14:06:25:841 CEST] 00000024 SystemOut O as400:
CallableStatement STMT0004 (1515870810) : Update count = 0.
[2-5-08 14:06:25:841 CEST] 00000024 SystemOut O as400:
CallableStatement STMT0004 (1515870810) : Result set = true.
[2-5-08 14:06:25:841 CEST] 00000024 SystemOut O as400:
CallableStatement STMT0004 (1515870810) : Number of result sets = 1.
[2-5-08 14:06:25:841 CEST] 00000024 SystemOut O as400:
CallableStatement STMT0004 (1515870810) : Row count estimate = -1.