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

Hibernate version:
3.0

Mapping documents:

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

Full stack trace of any exception that occurs:
OutOfMemoryException

Name and version of the database you are using:
PostGreSQL

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

I get an OutOfMemoryException in the hibernate persistency layer.
I use a C3p0 connection pool + PostGreSQL database.

When I run a memory profiler (Yourkit Java Profiler) I see that 'org.hibernate.persister.entity.SingleTableEntityPersister' and 'org.hibernate.impl.SessionFactoryImpl' is consuming the amount of memory.

I decreased already the used memory by closing the session after each loop in my code, but some persistency stuff still remains deep down in hibernate.
I use the default hibernateUtil implementation, so I create the hibernate session using sessionFactory.openSession()

Has somebody some suggestions.

Thanks.

We use scrolling along with evicting instances, or clearing hte cache...session.clear() to process large amounts of data.

Take a look at this link -
http://www.hibernate.org/hib_docs/v3/reference/en/html/performance.html#performance-sessioncache

With that it doesn't run out of memory.
Hope it helps