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... -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira