Hi,

I used a join type mapping to make a parent-child relation.
Nevertheless, when I take a look to the generated requests, It looks like Hibernate is using outer join to link the two tables. And so, as if it is to make requests on a hierarchie, response time are too long (2s for TOAD's with inner join and 59s with Hibernate's outer join).

Could anyone tell me if it is possible to make Hibernate not to do outer-join ?

Thx for your help !

============================

<class name="ReferenceMere" table="T_MAILLON_REF">
<comment>Reference Mere.</comment>

<composite-id name="id" class="ReferenceMere$Id">
<!-- code de la hierarchie : ici PFDC -->
<key-property name="coarh"/>
<!-- Numero de version -->
<key-property name="noverarh"/>
<!-- Numero de maillon -->
<key-property name="nomln"/>
</composite-id>

<!-- Sous Sous Gamme -->
<join table="T_PEREFILS_REF" >
<key unique="true">
<column name="coarh"/>
<column name="noverarh"/>
<column name="nomlnfis" />
</key>
<many-to-one name="sousSousGamme"
update="false"
not-null="true"
insert="false" unique="true">
<column name="coarh"/>
<column name="noverarh"/>
<column name="nomlnper"/>
</many-to-one>
</join>


</class>


============================