Hello,
I have been using the Hibernate Iteration functionality in order to scroll (only forward) a given query. I use this to paginate, so I have to leave the Session open once it keeps the Result Set open.
There is a specific situation where I need to get and object loaded in this session, making a couple changes and send it to be updated within the same Session. I have been doing this and have got no errors from Hibernate, although it is not saving the changes in the database, and even more weird, if I try to execute a select query from my SqlServer Query Analyzer, the tables related to the "change" are locked, the query never returns unless I close the open session.
Does anyone have any idea of what I might be doing wrong?

Hibernate version:
Hibernate 3.0

Name and version of the database you are using:
SqlServer 2000

Thanks in advance for any hint!