Hi All,

I am using Hibernate to query a table having more than 200000 records.
I used the session.createCriteria(<classname>).list() method. However this causes a ava.lang.OutOfMemoryError: Java heap space exception.

Is there any way in hibernate that i can read data in batches? i.e. read about 100 records, process them and then read the next 100 records?

Any help would be appreciated.

Thanks in advance.

Is it so hard to look at manual first ;-).

http://www.hibernate.org/hib_docs/v3/re ... batch.html

Regards,
Pavol

Thanks for pointing it out. However, the manual gives the process for handling only batch inserts and updates. I am facing the porblem for a select when i use Criteria.list(). Any points on that?

Well yes, ok, see this:

http://forum.hibernate.org/viewtopic.php?t=980052

Also don't forget to do flush and clear in the cycle to clear the session-level cache.

Regards,
Pavol