out of memory error

swetha · **Joined:** Thu Nov 30, 2006 8:49 pm **Posts:** 5

[b]Hibernate version: 3.1.3

[b]Full stack trace of any exception that occurs: java.lang.outofmemoryError

[b]Name and version of the database you are using: Oracle9i

can any one help me how to handle when we try to retrive more rows from database for example at about 50000....

I couldnt able to handle the situation. I am getting out of memory Error...

In Hibernate, is there any way to fetch the records partially not whole at a time.... for example loading records 20 at a time and again loading next 20...

lester · **Posted:** Fri Dec 01, 2006 5:54 am

Did you use Query.setFirstResult() and Query.setMaxResults() ?

CWitherow · **Posted:** Fri Dec 01, 2006 2:00 pm

Query has a scroll() method that returns a result iterator similar to using JDBC PreparedStatement/ResultSet.

StatelessSession may also be of interest to you.

Curtis ...

swetha · **Joined:** Thu Nov 30, 2006 8:49 pm **Posts:** 5

i have used the method scroll()... but its of no use ... Still i am getting the same exception... By using setFirstResult() and setMaxResult() we have to condense the retreival of rows... Cant we get the full rows.. ie all 50000 rows

thanhtom · **Joined:** Fri Dec 01, 2006 5:51 pm **Posts:** 4

I think the configuration hibernate.jdbc.fetch_size could be what you need (Section 3.5 of http://www.hibernate.org/hib_docs/refer ... ation.html)

ptat004 · **Joined:** Sat Dec 02, 2006 10:55 pm **Posts:** 10

WHy dont you try configuring the JVM heap itself (although i dont know much about data mining)

HibernateKing · **Joined:** Fri Dec 01, 2006 4:28 am **Posts:** 6

You need to increase the Java Heap Size.

swetha · **Joined:** Thu Nov 30, 2006 8:49 pm **Posts:** 5

how to increase the JVM heap size.. can anyone give me a hint

thanhtom · **Joined:** Fri Dec 01, 2006 5:51 pm **Posts:** 4

swetha wrote:

how to increase the JVM heap size.. can anyone give me a hint

I dont know how you start your JVM, however, you can pass the argument -Xms and -Xmx to your "java.exe" file to set Min/Max heap size (see: http://java.sun.com/j2se/1.4.2/docs/too ... /java.html)
Also, you can put these settings in the environment, for example
>set JAVA_OPTS=-mx256m (set max heap size = 256Mb)
>java bla bla...

Cheers,