The DB2 UniversalDriver closes the resultset after the first rs.next() returned false. So the sizelimit if clause, causes in an exception thrown bei the db2 jdbc driver.
the sizelimit can be checked without calling rs.next().

will patch it :-)
Additional Comments From bjoern.voss dated Wed Jun 07 13:17:17 CDT 2006 
the patch ... :-)
simply tested without junit. just systemtest in my test environment.

Additional Comments From endisd dated Fri Jun 09 17:26:46 CDT 2006 
Thanks for the patch. It has been applied to the source code.


=========================================================
Issue dump from jira
$VAR1 = {
          'priority' => '4',
          'customFieldValues' => [],
          'project' => 'PENROSE',
          'status' => '5',
          'components' => [
                            {
                              'name' => 'Adapter',
                              'id' => '10011'
                            }
                          ],
          'attachmentNames' => 'JDBCAdapter.patch',
          'reporter' => 'bjoern.voss',
          'key' => 'PENROSE-149',
          'assignee' => 'endisd',
          'summary' => 'DB2 JDBC Universal Driver Bug in JDBCAdapter',
          'id' => '10479',
          'updated' => '2008-08-08 10:31:46.0',
          'votes' => '0',
          'fixVersions' => [
                           {
                             'releaseDate' => '2006-06-12 00:00:00.0',
                             'sequence' => '12',
                             'name' => 'Penrose-1.0',
                             'released' => 'true',
                             'id' => '10072',
                             'archived' => 'false'
                           }
                         ],
          'description' => 'The DB2 UniversalDriver closes the resultset after the first rs.next() returned false. So the sizelimit if clause, causes in an exception thrown bei the db2 jdbc driver.
the sizelimit can be checked without calling rs.next().

will patch it :-)',
          'affectsVersions' => [
                               {
                                 'releaseDate' => '2006-06-12 00:00:00.0',
                                 'sequence' => '12',
                                 'name' => 'Penrose-1.0',
                                 'released' => 'true',
                                 'id' => '10072',
                                 'archived' => 'false'
                               }
                             ],
          'created' => '2006-06-07 13:15:48.0',
          'environment' => 'Windows XP SP2, JAVA SDK 1.5_06, DB2 Universal Driver 8.2 Fixpack 11',
          'resolution' => '1',
          'type' => '4'
        };


=========================================================