Paging with iBATIS

[ndijkstra]

Hi,
i've been looking for a way to implement paging in my application using iBATIS in an efficient way. This means that fetching all the records an apply paging with a Collection is disscarded.

What i would like to do is fetch only the necessary records from the database. An aproach could be using scrollable resultsets but i can't figure out how to integrate them with iBATIS transparently.

Thanks in advance.

[irbouho]

Take a look at ValueList (http://valuelist.sourceforge.net/). This open source project has adapters for Hibernate, iBatis... and is configurable via Spring.