Hello David,
Thanks for a quick reply,we can do this by ResultSet but actually i wanted to use it by CachedRowSet only,actually i was trying to do paging with on CachedRowSet. I know the paging can be done using using loop and there is another problem my
JSP grid where i am populating data it takes the whole CachedRowSet as an Object and display the result. Eg.
Suppose i have 2000 records in CachedRowSet so i m creating 4 different CachedRowSet. which will populate the result. and paging can be done through it.
Please do remember i am using
sun.jdbc.RowSet.CachedRowSet