hello everybody

when one needs to retrieve giant data volume from the database
which hibernate possibilities are there to optimize the operation
and not to block the database and what one should keep in mind?

It won't help just to do a

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

As maxResults here it is set to 50 .. what if I would like to retrieve
the other 50 when there are 100 .. or 100.000? Is there something
like pagination implemented?


Thanks and
see you


Hibernate version: 3.2
Name and version of the database you are using:Oracle

http://www.hibernate.org/116.html#A32

or u can use ScrollableResult to open cursor -> criteria.scroll(ScrollMode.FORWARD_ONLY)

don`t forget to evict object from session if u plan e.g. to iterate over all object in during one session