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

[Christian Bauer (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HB-1572?page=all ]
     
Christian Bauer resolved HB-1572:
---------------------------------

    Resolution: Rejected

Stay on http://forum.hibernate.org/


> 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