why use the query list obtain OutOfMemoryError

leng_cn · **Joined:** Thu Sep 29, 2005 9:54 pm **Posts:** 17

i use follow code get record but occoure a error is OutOfMemoryError

who can tell me why??????

Query qy = this.getSession().createQuery(hql);
qy.setMaxResults(15);
qy.setFirstResult(0);
recordCount = this.getRecordCount(initHql);
List result = qy.list();

another i have 10000 records in my table

how can i do?????

if only have 2000 records in my talbe

hasn't the error

why?????

rishi_ks · **Posted:** Thu Dec 08, 2005 7:15 am

Hi,
The issue you are facing is because the JVM runs out of heap memory.
This can be easily taken care of by using the following arguments in the startup of the java process:

Code:

java -Xms128M -Xmx256M

I am assuming you have at least 256M RAM in your machine.
Regards
rishi