Just applied a pull request that fixes the issue to master per these links:
https://lists.apache.org/thread.html/6561a3d616680468e36e173ad016c1b683024b12a35dfd5cae13c790@%3Cuser.cayenne.apache.org%3E https://issues.apache.org/jira/browse/CAY-2070 https://github.com/apache/cayenne/pull/92 Andrus > On Mar 30, 2016, at 1:16 PM, Simon Farner <s.far...@bluewin.ch> wrote: > > I will try this today. Reading it just in an mail I am still a bit > confused about what relationships are ultimate needed and which need to > be deleted, but I figure this will sort itself out when I get to play > around with it this evening > > Thank you for helping me out to everybody. If you eventually get around > to fix this I will be glad to offer my help in turn and try it out. > > Best regards > Simon >> >> "Sync ObjEntity with DbEntity" button in the Modeler insists on >> adding these relationships back (which is a bug and we need to >> address it). So make sure you delete those, if they are ever created >> during sync. >> >> HTH, >> Andrus >> >> --- a/datamap.map.xml >> +++ b/datamap.map.xml >> @@ -90,10 +90,6 @@ >> <db-relationship name="book" source="PAPER_BOOK" >> target="BOOK" toMany="false"> >> <db-attribute-pair source="ID" target="ID"/> >> </db-relationship> >> - <obj-relationship name="eBook" source="Book" target="EBook" >> deleteRule="Nullify" db-relationship-path="eBook.book"/> >> - <obj-relationship name="paperBook" source="Book" >> target="Book" deleteRule="Nullify" db-relationship- >> path="paperBook.book"/> >> - <obj-relationship name="book" source="EBook" target="Book" >> deleteRule="Nullify" db-relationship-path=""/> >> <obj-relationship name="artist" source="Painting" >> target="Artist" deleteRule="Nullify" db-relationship-path="artist"/> >> <obj-relationship name="gallery" source="Painting" >> target="Gallery" deleteRule="Nullify" db-relationship- >> path="gallery"/> >> - <obj-relationship name="book" source="PaperBook" >> target="Book" deleteRule="Nullify" db-relationship-path=""/> >>