Hi all,

I am trying to map a one-to-one relationship, the problem is in the parent table I dont have a reference to the child table, and it is the parent table that I retrive via hibernate.

This dosnt really cause an issue because hibernate maps the two tables ID's.

however I need to use a foreign key in the second table something like:

TableA
ID
name
otherColumn

TableB
ID
tableA_id
name
blah.

so that when I retrive TableA it gets TableB based on the tableA_id column.

I have tried to use both foreign-key and formula attributes in both tables mapping, but I still get the default behaviour.

I would rather avoid having a foreign key in TableA as it might not have a record in TableB and i dont really like having null columns in my data records if i can avoid it.

Any ideas or tips?

Thanks
G

This situation is documented in the hibernate reference:



So, for your example, in TableA.hbm.xml

And in TableB.hbm.xml

Ah. I didnt understand when I read that, I wqas a bit worried I would end up with a collection if i used the many to one.

I will give it a try.

Thanks

That seems to have solved it perfectly, thank you very much.

G