I'm trying to find an O/R framework that can perform paging.

The first type would be a query that would retrieve rows from a database using an Iterator. When next() is called rows are feteched as needed. This is useful for a client app that retrieves more rows from a database when the user moves the them in a list within a certain distance from the bottom.

The next type would use a query that supports JDBC bookmarks. The query would perform paging and keep only enough rows to keep a scrolling window populated.

As you've probably guessed this is for client development not web. We have created are oun framework that implements the first type and this works well using SWT as the gui.

What we want to avoid is a use performing a query and then retrieving 10,000 rows when they don not scroll through and then fire off another and another.. You get my point.

Any help on this would be appreciated.

Thanks
Darren.

query.iterate()
query.setMaxResults().setFirstResult()

Nics. Sorry about the delay in responding.

I'll give that a try.

I take it that this will hold a connection from the underlying connection manager?

I've got this working, but i was shocked to see that when i iterate over a query, the first sql statement just retrieves the keys. Every time next is called, hibernate fires another SQL statement to get the object. This is sloooooow.

How can i make hibernate select all attributes on the first query.

Any help would be appreciated.

Darren.

Thats the point of iterate(), use it if you expect the data to be cached in the second level cache. Otherwise, wait for 2.1.5 (due in the next days) and use scroll().

Ahhhh, i'll wait for 2.1.5 then. Thanks.