In addtion to all above I want to add this but I am not very sure about this and need inputs of other.
In my view
ResultSet does not hold any data rather It points to cursor in database and it makes a round trip to database whenever resultset.next() is called so there is no limit of resulset if there is any then it would be DB dependant
what is alternative to ResultSet which can hold more table of data
As far as I know there is no alternative of ResultSet even if you use CachedRowSet then also you need resultSet to populate it.
Shailesh
[ April 16, 2005: Message edited by: Shailesh Chandra ]