I know you can set restriction to get only 50 out of a large set.

Criteria crit = sess.createCriteria(Cat.class);
crit.setMaxResults(50);
List cats = crit.list();

But, after that, how do you get the next 50?

Hm. I guess something like:



Regards,
Pavol

would I have found this call in the " Relational Persistence for Idiomatic Java" documentation, or only in the api doc?

Or you can use scroll ?

http://www.hibernate.org/hib_docs/v3/re ... -scrolling

Pavol

Thanks. both replies are excellent.

this thread is not quite yet concluded. what happens when you are fetching the child list of an object?

I am using lazy fetching to start with, and calling

Hibernate.initialize(childList);

when I need to get the child list.

how do you control the list size in this case?

What do you mean under controlling the list size?

Pavol

if you have 1000 children in the list, and you don't want to fetch all of them out of the database, can you limit the fetched child list to the first 50, as is done with pagination using query.

Well, I don't think you can control the child list of parent in such way. You can set fetch size, but I think once someone needs the child list, it will be initialized completely.

What I would do is not having the child list, but some DAO layer, and in case you need to iterate the child list, it will scroll the query (control the size).

Pavol

that's what I pretty much concluded on my own. thanks for confirmation.