I am trying to map a legacy database which has relationships with no foreign key constraints. This means that occasionally table A will have a value for the primary key of table B but that value will not exist in table B. What I would like is an outer join mapping that makes the class association null in this case instead of throwing an exception.

Is this a simple matter of putting fetch=join on the many-to-one mapping?

Hibernate version:
3.2.6
Mapping documents:
None yet
Code between sessionFactory.openSession() and session.close():
N/A
Full stack trace of any exception that occurs:
N/A
Name and version of the database you are using:
Oracle 10g
The generated SQL (show_sql=true):
N/A
Debug level Hibernate log excerpt:
N/A

The <many-to-one> declaration can take a not-found attribute. Possible values are ignore and exception (the default).
See http://www.hibernate.org/hib_docs/v3/re ... -manytoone

Yes! Thanks for that, all is working now.