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

[swetha (JIRA)]

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.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira