Hibernate version: Looks like Hibernate 3.x

Mapping documents:

<many-to-one name="CatalogSource" class="com.xxx.yyy.domain.CatalogSource" insert="false" update="false">
<column name="SRC_ID" not-null="false"/>
<column name="MERC_SEAS_YR_ID" not-null="false"/>
</many-to-one>


Name and version of the database you are using: DB2

The generated SQL (show_sql=true):

inner join
zzz.CATALOG_SRC catsrc2_
on this_.SRC_ID=catsrc2_.SRC_ID
and this_.MERC_SEAS_YR_ID=catsrc2_.MERC_SEAS_YR_ID



I need to know how to change the mapping to make this an outer join. I've tried adding fetch="join" and/or outer-join="true". No luck so far.

Any help? Do I need to switch over to HQL?

Thanks,
-Tim

So what are you using right now to get the partial SQL? In HQL it is easy. Use
'left join' instead of 'join'.

This is the automatically generated SQL, copied from the log. Currently I am strictly using hibernate mapping files, not HQL.

Somewhere in your code you are doing something that generates the SQL. It would be nice if you could show that part of the code and also the complete SQL that it generates.