While retriveing data from postgres using hibernate 3.0 its taking too much of time some time its showing outofmemory error

query sample hsql query

from Candidatemaster as a where a.userpk in (select b.userpk from UserAddress as b where b.statepk=1 and b.addres_type=:code)

For Table we created index allso but it still showing out of memory error

how to solve it

thanks









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

Hibernate version:

Mapping documents:

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

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

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

Can you provide some more information:
- how large is the DB
- how much entries are in table Candidatemaster
- what SQL statement is generated
- how much memory is assigned to the JVM

try with

-Total tables=65
-Candidatemaster more than 1 lakh
-hsql - from Candidatemaster as a where a.userpk in (select b.userpk from UserAddress as b where b.statepk=1 and b.addres_type=:code)
- dont know (default JVM setting is used)