Hibernate V1.2

The map is too big to list here but for the overall picture
Meetings is the primary object
Each Meeting Has (N) Ballots
Each Ballot has (N) ProposalGroups
Each ProposalGroup has (N) Proposals

NO lazy loading is enabled

A join of every table for this query will result in 4700 records.

Issue #1) I Tried to use <bag> but a bag within a bag was throwing an exception.

Issue #2) Using <list> mappings and HQL I can make it work up to ProposalGroup. As soon as I add on LEFT JOIN fetch Propsals it crashes after about a minute due to excessive memory usage. The query is:
"from MeetingList as ml LEFT JOIN fetch ml.Ballots as b LEFT JOIN fetch
b.ProposalGroups as pg LEFT JOIN fetch pg.Proposals"


Issue #3) I tried to make nhibernate work with my own createSQLQuery but I cannot make it map over the sub collections. If I do it this way, I get 4700 meeting objects when it should really only be 750. Is there a way to do the same functionality that HQL gives you via your custom sql query?

If you are getting more objects than you expected, maybe you are getting the same object multiple times because of the joins?

If you retrieve objects using Criteria, have you used



?

Cheers,