Cool, it works now, and also filed CAY-326 in JIRA for the issue.
Thanks a lot Andrus, I knew it would come down to something simple.
-Nick
On 6/10/05, Andrus Adamchik <andru..bjectstyle.org> wrote:
> Nick,
>
> I was able to reproduce the problem. There was one more inconsistency in
> your mapping - to-many set from join table to its parents, when it should
> be to-one (see attached data map where this is fixed) ...
>
> However there is also a bug in the Modeler - once I changed to-many
> settings, incorrect classes were still generated. Once I closed and
> reopened the project, everything worked again. So "read-only" setting was
> cached incorrectly.
>
> Could you please open a bug report in Jira for that...
>
> Debugging it was surely a pain... I guess we may also add a visual
> indication for read only relationship with a mouse-over explanation of the
> reasons...
>
> Andrus
>
>
> > Ok, well I did this, and even went so far as to re-create all the
> > many-to-many relations/tables/etc all over again and still nothing.
> > Going to move on with out it for now, but hopefully we'll be able to
> > sort it out. :)
> >
> > -Nick
> >
> > On 6/10/05, Andrus Adamchik <andru..bjectstyle.org> wrote:
> >> You need to check it on the side of each master table: "tapn_users" and
> >> "tapn_forum", and UNcheck for the join table.
> >>
> >> Andrus
> >>
> >> > Ok, so I need to have the "To Dep PK" checked in which, the Forum
> >> > table, or the join table? As you can see, still confused. :)
> >> >
> >> > But, I think I tried it both ways and either way it didnt make a
> >> > difference, still only got getModerators and no add or remove methods
> >> > with it. (in either case, checking one or the other nothing in the
> >> > class changed. Should I recreate the relationships in the classes
> >> > after I check the boxes?)
> >> >
> >> > I think the biggest confusion has to do with the "TO" in the
> >> > description. Just taking that out would be better, "Dependent PK"
> >> > makes more sense to me at least. Or even, "Dependent ON PK" or
> >> > something like that.
> >> >
> >> > -Nick
> >> >
> >> > On 6/10/05, Andrus Adamchik <andru..bjectstyle.org> wrote:
> >> >> Nick,
> >> >>
> >> >> "to dep pk" has to be the other way around. What it means is that
> >> MASTER
> >> >> table propagates its PK to its DEPENDENT table. "tapn_users" and
> >> >> "tapn_forum" are both masters and "tapn_fmoderators" is a dependent
> >> >> table.
> >> >>
> >> >> BTW, if anybody can suggest a better name for this flag (or maybe a
> >> >> suggestion how to improve UI that sets it), please post your
> >> >> suggestions.
> >> >> While "to dep pk" is technically correct, it does cause confusion.
> >> >>
> >> >> Andrus
> >> >>
> >> >> > Just tried it, and nothing.
> >> >> >
> >> >> > Attaching the map file.
> >> >> >
> >> >> > Thanks again,
> >> >> > -Nick
> >> >> >
> >> >> > On 6/10/05, Andrus Adamchik <andru..bjectstyle.org> wrote:
> >> >> >> Hi Nick,
> >> >> >>
> >> >> >> Do you have "To Dep PK" checked for these two relationships:
> >> >> >>
> >> >> >> Forum->join table
> >> >> >> User -> join table
> >> >> >>
> >> >> >> If this doesn't help, please send your *.map.xml file - it may
> >> give
> >> >> some
> >> >> >> clues.
> >> >> >>
> >> >> >> Andrus
> >> >> >>
> >> >> >> > Ok, so I'm a newb to Cayenne and this has probably already been
> >> >> >> > answered, but since i can't find a searchable list archive
> >> >> anywhere,
> >> >> >> > here goes.
> >> >> >> >
> >> >> >> > I've got a many-to-many relationship I'm trying to build and it
> >> >> looks
> >> >> >> > like everything is working, but the classes generated only let
> >> me
> >> >> get
> >> >> >> > the list and not add to them. I've got a join table and
> >> >> relationship
> >> >> >> > to both ids and all the chained joins appear to be setup
> >> correctly
> >> >> in
> >> >> >> > the objects, but still no love.
> >> >> >> >
> >> >> >> > What am I missing to be able add to the join table? I've tried
> >> just
> >> >> >> > about every combo I can come up with, but there must be
> >> something.
> >> >> >> > BTW, this is with 1.2M4.
> >> >> >> >
> >> >> >> > This is a simple mapping:
> >> >> >> > Users can be moderators of several Forums
> >> >> >> > Forums can have several User moderators
> >> >> >> >
> >> >> >> > Join table with userId and forumId
> >> >> >> > user relationship going from the join table userId to user table
> >> Id
> >> >> >> > same for forums.
> >> >> >> >
> >> >> >> > Chained relations
> >> >> >> > Forum->join table -> user table
> >> >> >> > User -> join table -> forum table
> >> >> >> >
> >> >> >> > Thanks for the help!
> >> >> >> > -Nick
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >> >
> >> >>
> >> >>
> >> >
> >>
> >>
> >
>
>
>
This archive was generated by hypermail 2.0.0 : Fri Jun 10 2005 - 14:48:14 EDT