Hi!

I'd like to have an outer-join on a many-to-many association.

I tried the fetch and outer-join parameters in my mapping file, but the select that is get back is still the same (without outer join).

Here is my code :

<set name="disciplines" table="STI_STIFTUNG_DISCIPLINE" >
<key column="STI_ID"/>
<many-to-many class="Discipline" column="DISC_ID" />
</set>


Does somebody have a solution ?

Thanks in advance.

Joce

HQL always ignores the mapping document eager fetch setting.

You can:

1) set outer joins to true in your mapping file and use Criteria queries, or

2) use "outer join" in HQL queries


jd