Navigating through a Large RowSet
By sakthi on Jan 27, 2006
By Default, when database tables are dropped onto a page or a component like Table, it is configured to retrieve all rows on its execution. There are use cases where we don't want to be doing this, particularly, when table has thousands or millions of rows. In such cases, it would be good to set pagesize property appropriately, to limit the number of rows retrieved at a time.
This Sun Java Studio Creator 2 Sample Project available here demo's how to set up navigation through such large rowsets. It uses cachRowSet.nextPage() and crs.previousPage() to navigate through the rowsets.
Note: When clicking NextPage button for the first time, it doesn't navigate to the next page.Whereas successive clicks on NextPage works fine. This is a known issue in the product.