hi all,
i have A many-to-many B
and i want to construct a DOM like this:
<a1>
<b1/>
<b2/>
</a1>
<a2>
<b3/>
<b4/>
</a2>

the goal is to use only one (sql) query so i made this:


one shot query:

a1 b1
a1 b2
a2 b3
a2 b4

but i notice that the collections bs of a1 and a2 are not loaded and then 3000 queries are executed when calling
Databinder db = sessionFactory.openDatabinder();
db.setInitializeLazy(true);
db.bindAll((Collection)result);
Document dom = db.toGenericDOM();

1- if i replace
db.setInitializeLazy(true); by db.setInitializeLazy(false);
the db isn't hit but i do not have my 'bs' in my dom

2- if i replace lazy="true" by lazy="false" , i my mapping file, the 3000 sql queries are called just after the first query


I do not understand since all instances are in the sessions ;(

Thanks for help

grrrrr, always reading 100 times the doc and never notice a small keyword



and the keyword is FETCH and of course it is explained in the doc

so in my case if i keep lazy=true and change my query to


the result is what i need:
a1 b1
b2
a2 b3
b4

And thanks to hibernate to provide this doc,


Anthony