I'm using hibernate 3.2.2 and jboss 4.0.5

I've a huge database to be mapped, consinsting of more than 2000 inter-related tables

It's a legacy setup, so no changes could be done on the db.

The problem is that the startup of the hibernate session factory takes more than 2gb of ram to start.

using the verbose garbage collector, i've found out that the memory usage is 500mb after reading the mapping (hibernate.cfg.xml and relateive hbms) and jumps on 2gb after building the session factory. (under a test 64bit machine with 4gb ram)

the problem is that under a 32 bit architecture the jvm memory limit is 1.5 gb, so the session factory couldn't be built.

is there any way to reduce memory usage without loss of functionality (a performance loss is acceptable)? Something like lazy loading, but for relations and pojo definitions?

hi did u find any solution We have huge database and same problem with 32 bit machine?