I have a many-to-one relationship where the table on the "many" side may contain a foreign key to a non-existent row on the "one" side table. When accessing this, I get the error "No row with the given identifier exists".

I have added the outer-join="true" attribute and get the same error. Looking in the log, I see that a select was executed on the "many" table with an outer join on the "one" table. However, this is immediately followed by a select on the "one" table for the foreign key which if missing returns zero rows and causes the above error.

Is there a way to use the <many-to-one> mapping to allow the foreign key to optionally point to a missing row?

Hib 2.1.7
MySQL 4.1.10

Thanks.

you may have a problem with your data, hibernate may have retrieve an "id" that doesn't exist in one table, this is not related to outer-join.

[/quote]