[hibernate-issues] [Hibernate-JIRA] Resolved: (HB-1572) how to handle large number of records when retrieved from database

how to handle large number of records when retrieved from database ------------------------------------------------------------------ Key: HB-1572 URL: http://opensource.atlassian.com/projects/hibernate/browse/HB-1572 Project: Hibernate2 Type: Improvement

Environment: Java Reporter: swetha

I am using Hibernate3.1.3 and the database is Oracle 9i. I have a query such that it retrieves 800K records. In that case how to handle that many records. I could able to get upto 20K records. After that I am getting out of memory. Is there any limit for the retrieval of rows in Hibernate. I have using the ScrollResults, setFirstResult(), setMaxResult(). But I couldnt able to solve the problem. How to handle all the records? I have tried SatelessSession also. But at max. I can retrieve upto 20K. I have also used session.clear(), session.evict(). Can u help me in getting a solution... please...