Sanjay,
I have been using a CachedResultSet to handle my paging needs. I don't use it as a "paging" scroll, but instead as 25 records at a time. Here's a code sample:
<
jsp:useBean id="crs"
class="sun.jdbc.rowset.CachedRowSet" scope="session">
for(int j=0; (j<25) && crs.next(); j++) {
crs.getString("myColumn");
}
You will find quite a bit of useful methods in the CachedResultSet for your particular implementation.
regards,
mark