cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marc O'Morain" <>
Subject Re: How do I do a relationship on non-PKs in Modeler?
Date Sun, 04 Sep 2011 12:11:41 GMT
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


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

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message