You can either use queryForList(id,param, offset, limit).... Or the native range features of the SQL supported by your RDBMS.
The latter will likely have significant performance advantages, but iBATIS doesn't do anything special to support the pagination params in that case. I recommend testing out a few approaches to determine which is easiest for you to implement, maintain and which performs best. Clinton On Wed, May 21, 2008 at 1:51 PM, Josh Joy <[EMAIL PROTECTED]> wrote: > Hi, > > As others have pointed out, queryForPaginatedList is deprecated... > I found this old thread suggesting to handle it in sql itself... > http://www.nabble.com/Deprecated-paginatedList-td14253303.html > > Is that still advisable today? I have lots of queries that I need to have > pagination on...is there a simple way to streamline this using an Ibatis tag > or method? Or do I need to write out the sql... > > Thanks, > Josh >
