Hi Jo, 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 < joachim.durchh...@hennig-fahrzeugteile.de> 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 >
