I need to do something lik that:

1. Start ScrollableResults (FORWARD_ONLY)
2. Start loop through results
3. Start transaction
4. Do some work with entity
5. Commit transaction
6. End loop
7. Close ScrollableResults

The problem, is that I'm getting error "Cannot operate on closed ResultSet".
Batch update is not suitable for me, because of our architecture (one of the reasons is that we don't want to lock the objects in database for the lenghty process) and actually it's not a batch update, but data maintenance task.

There was a discussion already about that. It seems, that c3p0 gives this error. But there's no solution for that.

This problem affects 3.2.0 GA version. In 3.1.x version there weren't this kind of problems.

Maybe there is other way to iterate through objects whithout fetchin all them in memory?. Query.iterate() also gives the same error.

I'm doing exactly the same thing and am experiencing the same problem with Hibernate v3.1.3. Did you ever find a good solution to your problem? So far the only solution I've found is to set the following property:



but this doesn't seem like the best solution to me as it's a global setting and is not really recommended according to the manual. It seems to me this is actually a bug in Hibernate. Shouldn't Hibernate do a check for open resultsets/cursors instead of blindly releasing the connection at the end of a transaction?

Thanks,
Corey