Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.0

Mapping documents:
<hibernate-configuration>
<session-factory>
<!--SQL dialect-->
<property name="dialect">
org.hibernate.dialect.SQLServerDialect</property>
<!--JDDBC Connection pool-->
<property name="connection.pool_size">1</property>
<!-- comment things out as we move them to code-based configuration -->
<!--Echo all executed SQL to sdtout-->
<property name="show_sql">true</property>
<property name="jdbc.batch_size">20</property>
<!-- driver_class, url, username, password, and mapped resources will be
added in Java code -->
</session-factory>
</hibernate-configuration>

Code between sessionFactory.openSession() and session.close():
Full stack trace of any exception that occurs:

I have a query which returns around 380K rows. I understand with these things ScrollableResults is the way to go, so I did:

ScrollableResults sr = query.scroll(ScrollMode.FORWARD_ONLY);

This caused an OutOfMemoryError (no stack trace)

Is there a better way of doing this? Thanks

did you release memory by calling session.clear() when you iterated through the results?

Definitely need to clear() the session as you iterate through. Also bear in mind if you are manipulating those objects in any way they will be kept around in the action list until the transaction is committed so you might still get memory creep.