cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Armstrong" <siber...@gmail.com>
Subject Re: Creating Compound PKs
Date Mon, 04 Jun 2007 07:22:00 GMT
I see your consideration on the id triple key and completely agree
with your points. I do have my relationships mapped and its been
running very smoothly.

Time to edit the DB. I've been avoiding it so far since I'm working
with Derby, its been quite nice!

Thanks for taking the time to answer my newbie questions. Just
starting into Cayenne and am enjoying it greatly. Its reducing the
development time on my app substantially.

John-

On 6/4/07, Andrus Adamchik <andrus@objectstyle.org> wrote:
>
> On Jun 4, 2007, at 9:52 AM, John Armstrong wrote:
>
> > I can enforce it unique in the database but I was thinking that
> > Cayenne may have a more elegant way of managing it without having to
> > manually apply the database changes after schema creation. To me that
> > screamed 'New compound PK'.
>
> To me it doesn't :-)
>
> Seriously, ORM tool (CayenneModeler) doesn't attempt to replace your
> DB management tools 100%, although it overlaps a lot. You should
> still use DB facilities as appropriate.
>
> > How do you create compound PK's in Cayenne? I'm still using the
> > Modeller so I may have to edit the XML natively?
>
> Go to the attributes tab of the given DbEntity and check the PK
> checkboxes of those two extra columns.
>
> But note that you would need to delete the "id" column then,
> otherwise the UNIQUE constraint would span all three columns, not
> just the two you wanted.
>
> Also you would need to mark a relationship from ImapServer to the
> table in question as "To Dep Pk", so that the serverid could be
> propagated whenever you do  myObject.setServer(myServer).
>
> Andrus
>

Mime
View raw message