Hi again Matt! Thanks for your response,
On Oct 15, 3:32 am, Matt Quackenbush <[email protected]> wrote: > Transfer does not allow you to have two different objects with an o2m like > you are describing. Can you please show us the relevant XML from your > transfer.xml file? Here's the transfer.xml: <package name="dc"> <object name="Person" table="DC_PERSONS" decorator="dc.model.decorators.Person"> <id name="PersonId" column="PERSON_ID" type="string" generate="false" /> <property name="FirstName" type="string" nullable="false" column="FIRST_NAME"/> <property name="FamilyName" type="string" nullable="false" column="FAMILY_NAME"/> <manytoone name="Country" lazy="true"> <link column="COUNTRY_CODE" to="dc.Country" /> </manytoone> <onetomany name="PersonOrg" lazy="true"> <link to="dc.PersonRole" column="PERSON_ID" /> <collection type="array"></collection> </onetomany> </object> <object name="Org" table="DC_ORGANISATIONS" decorator="dc.model.decorators.Org"> <id name="OrgId" type="string" generate="false" column="ORG_ID" /> <property name="CommonName" type="string" nullable="false" column="COMMON_NAME" /> <manytoone name="Country" lazy="true"> <link column="COUNTRY_CODE" to="dc.Country" /> </manytoone> <onetomany name="PersonOrg" lazy="true"> <link to="dc.PersonOrg" column="ORG_ID" /> <collection type="struct"><key property="PersonId"/></collection> </onetomany> </object> <object name="Country" table="DC_COUNTRIES"> <id name="CountryCode" type="string" generate="false" column="COUNTRY_CODE" /> <property name="CountryName" type="string" nullable="false" column="COUNTRY_NAME" /> </object> <object name="PersonOrg" table="DC_PERSON_ROLE" > <id name="PersonOrgId" column="PERSON_ORG_ID" type="string" generate="false" /> <property name="PersonId" type="string" nullable="false" column="PERSON_ID" /> <property name="OrgId" type="string" nullable="true" column="ORG_ID" / > <property name="RoleId" type="string" nullable="false" column="ROLE_ID" /> </object> </package> Obviously, PersonId and OrgId are foreign keys in PersonOrg. The same person can have different roles in the sale organisation. Pedro. --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
