Hi I' am working with Hibernate 2.1.8 , tomcat 4.1, jdk 1.3.1 and sql server 8 (jtds-1.1.jar)

I have a problem when I try to get more than 5000 paging rows because the hibernate doesn't finish to load the data in the memory (I know that because I'm running tomcat in Jprofile 4.2.2) and then I have an out of memory error because the heap size gets the limit.(I'm setting the heap size of JVM and Tomcat with -Xms256m -Xmx512M)


So, I need to know how to solve that and how many number of rows hibernate supports or how many rows hibernate works well.


2007-02-26 14:49:11|Thread-130 java.lang.OutOfMemoryError
; <<no stack trace available>>

Have you already tried how many rows you can retrieve when you set the memory, for example, to 512 / 1024?

No, the idea is that if I use 512 or 1024, I always have the problem "out of memory" because I want to get more than 5000 rows (for example 10000, 15000, 20000, etc...). For that I want to know If there is a standar number of rows that hibernate supports.


I do that:

List resp = this.getHsession().find(sql, new Object[]{cini.getTime(), cfin.getTime()}, new Type[]{ Hibernate.TIMESTAMP, Hibernate.TIMESTAMP} );


and then Hibernate stops in nef.sf.hibernate.loader.Loader.getRow() to load the data.

ummm, could you simply be running out of memory? What are your JVM settings i.e. -Xms -Xmx

How big are each of your datarows?

A simple way to test if this is a hibernate issue (which would seem highly doubtful) would be to create a simple table and bang 10000 rows in it and retreive them back.

Failing that, a tool like Your Kit Java profiler can proably help you spot where references are being held...