Name: gm110360 Date: 07/25/2003


FULL PRODUCT VERSION :
java version "1.3.0"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.0-C)
Java HotSpot(TM) Client VM (build 1.3.0-C, mixed mode)


FULL OPERATING SYSTEM VERSION :
Windows XP Professional

A DESCRIPTION OF THE PROBLEM :
A user should have some way to directly get the number of
rows returned from a JDBC ResultSet.

Also paging of result set should be available as part of
the standard JDBC API.

REPRODUCIBILITY :
This bug can be reproduced always.

CUSTOMER WORKAROUND :
Scroll Through the result set and count the number of rows
and then reexecute the query; else fetch a scrollable
result set and scroll through the result set to get the
count.

For Paging we are forced to write our own components. I
wrote one which mirrored the API as available in ADO (MS$).
(Incident Review ID: 168339)
======================================================================