Hello, I have a parent/child relation ( Customer/Order ) with composite id. My schema is this :

CUSTOMERS :

COMPANY_CODE
CUSTOMER_ID
CUSTOMER_NAME


ORDERS :

COMPANY_CODE
ORDER_ID
DATE
CUSTOMER_ID



<hibernate-mapping>

<class name="business.Customer" table="CUSTOMERS">

<composite-id>
<key-property name="companyCode" column="COMPANY_CODE"/>
<key-property name="customerId" column="CUSTOMER_ID"/>
</composite-id>

<property name="name"/>

<set name="orders" inverse="true" lazy="true">
<key>
<column name="COMPANY_CODE"/>
<column name="CUSTOMER_ID"/>
</key>
<one-to-many class="business.Order"/>
</set>

</class>

<class name="business.Order" table="ORDERS">

<composite-id>

<key-property name="companyCode" column="COMPANY_CODE"/>
<key-property name="orderId" column="ORDER_ID"/>

</composite-id>

<property name="date"/>

<many-to-one name="customer" insert="false" update="false">
<column name="COMPANY_CODE"/>
<column name="CUSTOMER_ID"/>
</many-to-one>



</class>


</hibernate-mapping>


Inserting a Order work, but CUSTOMER_ID is ZERO. This is because <many-to-one name="customer" insert="false" update="false">. But if I remove insert="false" and update="false" I get this Error :

net.sf.hibernate.MappingException: Repeated column in mapping for class business.Order should be mapped with insert="false" update="false": COMPANY_CODE


Could you tell me how can I solve this problem

Thanks

This is a common problem with composite ids in hibernate, and one reason I don't use them anymore.

Your column reference in the customer many-to-one in the business.Order class will have to be to a different column than COMPANY_CODE. That's already being used in the composite-id. Try something like CUTOMER_COMPANY_CODE. It will have the same data as COMPANY_CODE. Yes, I know this is redundant and breaks normalization.

Gavin has said many times that this is a difficult problem to get around and it won't be fixed any time soon.

http://forum.hibernate.org/viewtopic.php?t=925446
http://forum.hibernate.org/viewtopic.php?t=927698

Ok, my problem is that I've got a Legacy system database, all tables had already been created, and I can't change their structure. So, this will not be solutioned ???

Very thanks for your replies

That's my guess. You can create a JIRA request, but it would probably be rejected. The Hibernate team seems pretty opposed to composite id's in general, so I doubt they'd expand much on features involving them.

ok, thanks for your reply. Do you think that with JDO I can solve this problem ???

Thank you very much

How should we know?

Sorry, jlm. I haven't used JDO so I don't know.

Keep many-to-one insert and update false
And add a property mapping CUSTOMER_ID to customerId
Then fill it manually or write a smart non mapped setter filling it.