I have 2 tables that have identical composite keys. The 2 tables are mapped to domain objects and they both work as expected when treated individually. I would like (for convenience) to map them in a one-to-one relationship but I am having difficulty referencing the other's key using the property-ref.

Here are my mappings:

[code]<hibernate-mapping>
<class name="ownit.value.Reconciliation" table="Reconciliation" dynamic-insert="true" dynamic-update="true">

<composite-id name="loanKey" class="ownit.value.LoanKey" access="property">
<key-property name="loanNumber" column="gen_loan" type="java.lang.String"/>
<key-property name="settleDate" column="orig_settle_date" type="java.sql.Timestamp"/>
</composite-id>
</class>
</hibernate-mapping>

<hibernate-mapping>
<class name="ownit.value.Funding" table="Funding" dynamic-insert="true" dynamic-update="true">

<composite-id name="loanKey" class="ownit.value.LoanKey" access="property">
<key-property name="loanNumber" column="gen_loan" type="java.lang.String"/>
<key-property name="settleDate" column="orig_settle_date" type="java.sql.Timestamp"/>
</composite-id>

[b]<one-to-one name="recon" class="ownit.value.Reconciliation" property-ref="loanKey"/>[/b]

</class>
</hibernate[/code]


When I initialize hibernate and it loads the Funding mapping I get a MappingException: [b]property-ref not found: loanKeyin entity: ownit.value.Reconciliation[/b]

What is the appropriate way to map this relationship?

Perhaps you do not need to use property-ref

<one-to-one name="recon" class="ownit.value.Reconciliation" constrained="true" />

http://www.hibernate.org/hib_docs/v3/re ... tional-121