Hi,
I'm using Hibernate 2.0.3 with Firebird and (of course) the Interbase dialect.

I have a one-to-one relashionship between two classes, Listing and Instrument. hibernate.use_outer_join is set to true (and I can see it in the log output) but when loading listings outer join is not used, resulting in a query for loading listings and subsequent x queries for loading the associated instruments.

Thank you for any help :)
Massimo

// code snippet
List listings = session.find("from Listing listing");

This is an extract of the mapping

<class name="Listing" table="listing">
<id name="id" type="integer">
<generator class="assigned"/>
</id>
<timestamp name="lastModified"/>

...

<one-to-one name="instrument" cascade="all" class="Instrument"/>
</class>

<class name="Instrument" table="instrument">
<id name="id" type="integer">
<generator class="assigned"/>
</id>

...

</class>

For completeness I answer to myself :)
I achieved what I needed (associacion of instruments initialized with listings) using the fetch keyword and a left join:

select listing from Listing as listings
left join fetch listing.insturment as instrument

Regards
Massimo