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.