[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-521) ScrollableResults from Criteria class

[<leg...@at...>]

The following comment has been added to this issue:

     Author: Don DeLuca
    Created: Fri, 5 Dec 2003 7:26 AM
       Body:
I'm using ScrollableResults as a way to iterate through a large
result set.  I have some business logic that will iterate through
this and process each row.  I don't want to take the 
hit of buffering all the rows into a List.  For my use case I don't need all the "scrolling" functionality but I want to leverage how its a facade over the underlying JDBC ResultSet.

If I understand the Criteria.list() and Query.list() methods correctly these fetch all the rows and returns a fully populated List.  

I don't want to take the resource hit if I can avoid it.




---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-521


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-521
    Summary: ScrollableResults from Criteria class
       Type: New Feature

     Status: Unassigned
   Priority: Minor

    Project: Hibernate2
 Components: 
             core

   Assignee: 
   Reporter: Don DeLuca

    Created: Thu, 4 Dec 2003 10:00 AM
    Updated: Fri, 5 Dec 2003 7:26 AM
Environment: JDBC 2.0 compliant database that supports result set scrolling.

Description:
I've been using the Criteria API provided by Hibernate.  Its really excellent.  

Would it be possible to provide scrolling functionality in the Criteria API similar to that in the Query API which has a scroll() method that returns a ScrollableResults object.


---------------------------------------------------------------------
JIRA INFORMATION:
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

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira