Read the rules before posting!
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.0
Just a general question.....

Does hibernate have an equivalent next() method that will go to the db to get the next row??

SITUATION:

I would like to process about 5 million rows.
I do not want to load all those object into memory. I want to be able to do a next().

Does the Hibernate Query.scroll() check the cache first or it goes directly to the "cursor/resultset" and then creates the object as you call q.scroll??

Thanks,

Kenny





Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Just use something like

Query q = session.createQuery("from User as u where u.userName = ?");
q.setString(0, "Gerhard");
ScrollableResults users = q.scroll();
while ( users.next() ) {
User user = (User) users.get(0);
}

This worked for us. We could manage very large
number of objects.
Hope this helps.

Will do!!

Thanks,

Kenny