Pagination in JSP

Discussions

Web tier: servlets, JSP, Web frameworks: Pagination in JSP

  1. Pagination in JSP (1 messages)

    Hi all, I get an internal server error when I try to open a jsp page . The data served to this jsp page is retrieved through the execution of a dynamic stored procedure.When the resultset is more like >500.500 records have to be shown in the jsp. I am getting this internal server error.. To solve this issue can I use cached resultset.. or is there any other way to solve this issue.. please give ur thoughts and concerns thanks in advance GK

    Threaded Messages (1)

  2. Re: Pagination in JSP[ Go to top ]

    Just use ResultSet.absolute() to skip a certain amount of records. If you show 500 records per page, than you should call something like ResultSet.absolute(page * 500) to skip the amount of records requried for a certain page. Than use a loop to make sure you return no more than 500 records. Java Development on Demand http://www.hitech.com.ua/en/