Hi Friend i am facing problem in fetch records that why i join this forum.

my problem is that i having database around 800 tables and i generate hbm and Pojo using Hibernate reverse Engineering wizard.that tool generate mapping file and pojo fine.but when i am testing :-suppose i want to fetch Product from Product table .i write a query "from Product" then it will take long time to give the output..some time it give heap memory error.i know that n+1 select problem.but iam only testing.


one thing is that when i testing my generated mapping files with same project to myEclipse HQL editor it give output very fast.only it giving slow output when i am running the application.i am using only javaproject in myeclipse not any web project.and printing out put in console.

i don't understand what is the problem.......
can any one give me solution???
Thanks in advance.
Regadrs
Amit Rawat

i think it will becoz of loadging mapping files.i have to many mapping files and pojo for that.....iam using 3.2 hibernate specification for that.......my DTD are
:<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

and iam using cdlib 2.1 so whats the problem.plz tell me......is it anything wrong with dtd specification.
Thanks
Amit Rawat