Hi All

Using Hibernate for the first time and I'm having some teething problems...

Mapping document 1
=============

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="com.lmig.pal.pcm.cargo">

<class name="TCMClaimCenterGroupCargo"
table="CC_GROUP"
mutable="false">

<id name="id"
type="java.lang.Integer"
column="ID"
unsaved-value="null">
<generator class="assigned"/>
</id>

<many-to-one name="lmOfficeCodeType"
class="TCMClaimCenterLmGroupTypeCargo"
column="LMOFFICECODETYPE"
cascade="all"
unique="true"
fetch="join"
lazy="false"/>

<property name="groupType" type="java.lang.Integer" column="GROUPTYPE" />

<property name="lmOfficeCode" type="java.lang.String" column="LMOFFICECODE" />
<property name="publicId" type="java.lang.String" column="PUBLICID" />
<property name="name" type="java.lang.String" column="NAME" />
<property name="lmOfficeAddressLine2" type="java.lang.String" column="LMOFFADDRESSLINE2" />
<property name="lmOfficeCountry" type="java.lang.String" column="LMOFFCOUNTRY" />
<property name="lmOfficeName" type="java.lang.String" column="LMOFFICENAME" />
<property name="lmOfficePostalCode" type="java.lang.String" column="LMOFFPOSTALCODE" />
<property name="lmOfficePhone" type="java.lang.String" column="LMOFFPHONE" />
<property name="lmOfficeCity" type="java.lang.String" column="LMOFFCITY" />
<property name="lmOfficeCityDenorm" type="java.lang.String" column="LMOFFCITYDENORM" />
<property name="lmOfficeAddressLine1" type="java.lang.String" column="LMOFFADDRESSLINE1" />

</class>

</hibernate-mapping>


Mapping Document 2
==============

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="com.lmig.pal.pcm.cargo">

<class name="TCMClaimCenterLmGroupTypeCargo"
table="CCTL_LMOFFICECODETYPE"
mutable="false">

<id name="id"
type="java.lang.Integer"
column="ID"
unsaved-value="null">
<generator class="assigned"/>
</id>

<property name="priority" type="java.lang.Integer" column="PRIORITY" />
<property name="name" type="java.lang.String" column="NAME" />
<property name="description" type="java.lang.String" column="DESCRIPTION" />
<property name="typeCode" type="java.lang.String" column="TYPECODE" />
<property name="retired" type="java.lang.String" column="RETIRED" />

</class>

</hibernate-mapping>


Problem
======

My many-to-one association is generating an outer left join (I turned on show_sql to verify this) but I want it to generate an inner join - completely at a loss how to do this. I've tried looking at Hibernate in Action and looking at this forum but haven't had any luck.

Can anyone help me?