I was able to do this in the past by editing the .map.xml file by hand to
add the relationships. To do this I added a foreign key on the database for
one table temporarily, and let Cayenne infer this relationship. This
produced the relationship that I needed. I was then able to delete the
foreign key, and hand-write the other relationships to match the first.
It worked surprisingly well, but the real fix is to add foreign keys to your
database.
Marc
On Fri, Aug 26, 2011 at 10:53 AM, Durchholz, Joachim wrote:
Just to keep people informed: I have found the right incantation.
As Joel has noted, it's an awful lot of steps.
Also, Modeler isn't really very intuitive. For example, I'm entirely
confused about what you're supposed to do with classes and what should be
done with tables. Too many irregularly-formed Lego blocks (possible
configuration options), too little explanations how they're supposed to work
together.
Just as a feedback. I'm not working actively with Modeler right now (we had
to postpone the Hibernate->Cayenne migration), I'm pretty sure I'll be able
to figure it all out once I have more time for this.
Regards,
Jo
Just to keep people informed: I have found the right incantation.
As Joel has noted, it's an awful lot of steps.
Also, Modeler isn't really very intuitive. For example, I'm entirely
confused about what you're supposed to do with classes and what should be
done with tables. Too many irregularly-formed Lego blocks (possible
configuration options), too little explanations how they're supposed to work
together.
Just as a feedback. I'm not working actively with Modeler right now (we had
to postpone the Hibernate->Cayenne migration), I'm pretty sure I'll be able
to figure it all out once I have more time for this.
Regards,
Jo
