Hibernate version: 3.2

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

Full stack trace of any exception that occurs:

Name and version of the database you are using: MySQL 5.0


Hello everybody,

I have a database from where I have to load and process millions of records. Obviously it is impossible to use .list() for memory reason.

I have read several topic about the possibility of scrolling the results by page. I just dont understand what is the behavior of hibernate when a scrolling is made over a database where the content is changing ?

And is there any way for loading data directly into a file (like a listToFile() trick ?). I am sure that I am not the only one facing the problem of huge data loading/processing :)