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

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/