Java EE (Java Enterprise Edition) General Discussion

Hi Guys

I need some pagination in my JSP page, I looked thru the forums , found a lot of solutions. The only solution I can do is to keep the result in a collection object and store it in the session and page thru it.

I would like to bring only the data that need to be displayed, if one page is 20 rows bring only 20 rows. The problem I have is the order on which the data is displayed is on descending order of one column which can have a lot of duplicate values. For eg: the total number of lines in an order.

In this case , I donot know how to get the next page /prev page data depending on the last row of the current page..

Does anyone has come across this scenario and have a solution??

Thanks