Hi,

I want to retrieve say 100,000 records from the database table. I want to do it in batches of 1000 so that it doesnt throw an out of memory error. Is there any way to fetch the first 1000 records and then the next 1000 until all the records are fetched.
How will hibernate know to fetch the next 1000 records. Is it possible for hibernate to track the records that is already retrieved so that it can retrieve the next batch of records.

Thanks