Hi,

Can anybody help me with what should be a simple mapping in Hibernate 3.0 ?

I require a simple uni-directional one-to-one mapping between two tables where neither join column on both tables is a primary key. The following basic declaration allows me to specify the join column, via a property-ref, on the table I am joining to ...

<one-to-one name="cduRec" property-ref="pcisNumber"/>

This works fine, however it stills attempts to map the id column in the enclosing mapping file to that column. I wish to specify an alternative column.

Thx

Not sure to get it right, but it sounds as a (database) design problem to me.