Windchill JCA - how to load data one page at a time

How do you load data from database one page at a time using Windchill JCA?  We have a custom JCA application that loads data from a database into a web page.  When it gets to 2000 rows it throws the warning error row limit has been reach.  When I try to hit the Next button the table goes blank.  When I press previous the table goes blank again.  How can I load a table one page at a time to avoid reaching the max rows?  Does anyone have any examples?