Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: error (nike.apache.org: local policy)
MIME-Version: 1.0
In-Reply-To: <F673F472-FE94-45B3-B9C4-3F56430280CC@gmail.com>
References: <F673F472-FE94-45B3-B9C4-3F56430280CC@gmail.com>
From: Michael Gentry <mgentry@masslight.net>
Date: Mon, 5 Aug 2013 19:31:47 -0400
Message-ID: 
 <CAA-upzoXWnminEinDRuw5arXLtGzi5Ty9jD5kcAxFavOrzTMxg@mail.gmail.com>
Subject: Re: Flattened relationships
To: Cayenne Users <user@cayenne.apache.org>
Content-Type: text/plain; charset=ISO-8859-1

Hi Tony,

Does your UserRole have more than 2 FKs in it?  Did you map UserRole
to a Java class in addition to the DB mapping or do you just have the
DB mapping?  You should be able to do what you want.  I happen to have
an old working example here that does exactly what you are describing:

https://github.com/mrg/cbe/blob/master/InsertingObjects/ManyToMany/src/main/java/cbe/inserting/ManyToMany.java

The complete project has a model you can reference, too.

mrg

On Mon, Aug 5, 2013 at 7:03 PM, Tony Giaccone <tgiaccone@gmail.com> wrote:
>
> I have a User a Role and a UserRole. UserRole represents the Join Table between the two.
>
> The User has a flattened relationship through UserRole to Roles. It's marked as to many, list.
>
> The Role had a flattened relationship to Users it's marked in the modeler as to many, read-only, list.
>
>
> I want to add a standard role to the user. I fetch the role, create the user. The use:
>
> newUser.addToRoles(userRole);
> context.commitChanges();
>
> And an exception gets thrown.
>
> Cannot set the read-only flattened relationship 'users' in ObjEntity 'Role'
>
> What am I missing? Do I need accessors for the UserRole? I thought I could Dispose of that class. I'm confused.
>
> Tony Giaccone
>