Read the rules before posting!
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3 beta4

Mapping documents:

Code between sessionFactory.openSession() and session.close():
Query qry = session.createQuery("from eg.items");
List list = qry.list();

Full stack trace of any exception that occurs:
java.lang.OutOfMemoryError
Exception in thread "main"

Name and version of the database you are using:
Oracle 9i

I was doing a select query when the above codes generated an OutOfMemory Error. The number of records that I am trying to get is more than 50K. The OutOfMemory Error hits when qry.list() is executed.

Of course you get an OutOfMemoryException, you are loading 50k objects. Please read http://blog.hibernate.org/cgi-bin/blosx ... batch.html

Thanks!

That really helps!