Hi All,

I'm not sure if it's the right place to post this question. But this forum has many DB experts, i'm hoping to get the right answer from the members of this forum.

The question is that, assume that the client requests first 50 rows from the result set that matches a given query but there could be as much as 2000 rows. While retrieving the ResultSet, is it possible to return the first 50 rows to the client but at the same time continue to retrieve the rest of the 1500 rows? When the next time, the clients requests the matching results for the same query, will we be able to return the rest of the rows? Is it supported by the JDBC ResultSet or any other way?

Please note that our current Phase 1 project does NOT use hibernate but if there is a possible solution, we would want to implement this in Phase 2 which will use hibernate 3.

Thanks in advance!