Hello,

I have a problem that seems to have already been identified but with no answer.

I have a parent object with 5 child objects in one-to-one relationships. I want to load the parent and the 5 childs in one SQL request.
So I set fetch=join on the 1-1 relationships in the parent mapping file.

When I call Initialize() or when I access the parent object I see that there is one SQL statement with all the outer-join in it and this can initialize all objects. However NHibernate also issue 5 select on the child tables.

Is this behavior normal ?
Is there something missing in my mapping file ?

Ex of mapping of 1-1 in the parent:
<one-to-one name="Child1"
class="blablabla"
property-ref="ParentPropInChild"
cascade="all" lazy="proxy"
fetch="join" />

Thanks a lot,
Florent

well that's just because of lazy="proxy", cause that forces hibernate to create a proxy for the referenced object, and the proxy would be initialized on first access to accessor methods....

Well I thought it was like the outer-join="true" in the one-to-many that makes the proxies beeing initialized at once in one SQL request.

And if it-s not the case what's the use of fetch=join ? Why select all tables in one request if it is to select the same joined tables again one by one ?

Florent