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

Hibernate version: 3.2.x

Mapping documents: Native SQL

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

Full stack trace of any exception that occurs:

Name and version of the database you are using:DB2

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?N

Read this: http://hibernate.org/42.html

We are generating JasperReport from Hibernate using Native SQL. The problem is if the resultset is more then 100,000 records then its throwing outofmemory.

Is there a way retrieve 1000 records at a time from DB2 and put it into a report ?

Hi,

what is your system environment?
Normally 100.000 records shouldn't be that problem, when you have enough memory. -Xmx is set to an appropriate size? You only fetch the columns you need for the report?

Try verbose:gc (http://java.sun.com/developer/technicalArticles/Programming/GCPortal/) together with heap-profiling tool to find the bottleneck.