Hi,
I am not sure if my question is relevant to the
JDBC forum or
JSP forum. But I am posting it in this forum, as I believe this would have been implemented by my fellow JSP developers hanging out here.
We are required to retrieve rows from database and display it in JSPs with pagination support.(something like 50 items per page). The number of records returned could be different each time, the user selects a different filter criteria.
I am planning to use a ResultSet and store it in the User's Session/State data(Actually PageFlow in Weblogic). As each Pageflow(
servlet) instance is unique to a user, I guess there wouldn't be any thread-safety issues. I believe ResultSet has an open connection to the database and I can iterate over it multiple times, either forwards or backwards.
Would like to know, it there is a better approach than this.
thanks,
Vishwa