Every guy has a house. Every car has a house. How oh how do I map a one-to-one relationship between two foreign keys? I'm losing it.



Guy.hbm.xml

<property name="houseId" column="HOUSE_ID" type="java.lang.Long" insert="false" update="false"/>

<one-to-one name="car" class="Car" property-ref="houseId"/>



Car.hbm.xml

<property name="houseId" column="HOUSE_ID" type="java.lang.Long" insert="false" update="false"/>

<one-to-one name="guy" class="Guy" property-ref="houseId"/>



Still tries to join to one or the other primary keys...Am I crazy to think you should be able to join on two not-that-arbitray fields?

This sucker is a dup...can't delete it...Please post to the other thread...

No you are not crasy. yet.

Have you tried the foreign-key attribute?

http://www.hibernate.org/hib_docs/v3/reference/en/html/mapping.html#mapping-declaration-onetoone

Etienne.