cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marc O'Morain" <marc.omor...@swrve.com>
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
database.

Marc

On Fri, Aug 26, 2011 at 10:53 AM, Durchholz, Joachim <
Joachim.Durchholz@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
>

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