Hi,

I have the following association:

...
<class name="Employee">
<id name="employeeId" column="employeeId">
<generator class="assigned" />
</id>
<many-to-one name="department" column="departmentId" class="Department" cascade="save-update" lazy="false" fetch="join"/>
...

Looking at the log output there are two selects instead of one using a left outer join:

select
employee0_.employeeId as employeeId1_,
employee0_.departmentId as departme2_1_,
employee0_.lastname as lastname1_,
employee0_.firstname as firstname1_,
employee0_.employeeCode as employee5_1_
from
Employee employee0_
where
departmentId=1

select
department0_.departmentId as departme1_0_0_,
department0_.departmentCode as departme2_0_0_,
department0_.name as name0_0_
from
Department department0_
where
department0_.departmentId=?

Shouldn't there only be one select statement as the fetch-attribute mandates? What is wrong here? TIA,

Kari

According to the reference documentation that still might depend on the way you retrieve the object. See paragraph 19.1.2.