Hi,

We are using Hibernate 3.2 with JPA 2.0.

We are in process of replacing TopLink with Hibernate. While conversion come across the query which fetch large amount of data from database. TopLink does support CursoredIterator to fetch data in batch. I looking for same solution in hibernate. I can do it in hibernate using setFirst() and setMaxResult() with Query. But does not give correct result if some body delete or insert record while fetching records in batch.

Appreciate for reply for solution.

Thanks