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?

No you are not crazy. yet.

Have you tried the foreign-key attribute?

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

I'm curious as to why you would want to join a Guy to a Car using the houseId ?

I would also think you would map the Guy and Car as <many-to-one> with House since, theoretically at least, more than 1 guy can have the same house.

Perhaps bad example, but guy-house is one-to-one and and house-car is one-to-one...I want to join them directly to avoid uglier and train wreckier code:

guy.getHouse.getCar()...

Could just be

guy.getCar();

I'm too dumb to figure out the foreign-key attributes...I started reading about various constraints and my eyes glazed over.

Have you tried formula?

Formula?? I've checked out a couple of books, and they only seem to cover the most common one-to-one mappings...Rrr...

I'm pretty sure formula is new in H3 and probably isn't in any of the books yet. Check out the reference docs.