Issue with same entity relationship

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Issue with same entity relationship

Amedeo Mantica
Hi all,

I have setup a Table with self entity relationship (let say parent/children)

so in database I have along with other columns:

ID
PARENT_ID

set with relationship:



Code:

ObjectContext ec = databaseController.newContext();

        DCTest t1 = Cayenne.objectForPK(ec, DCTest.class, 1000000);
        DCTest t2 = Cayenne.objectForPK(ec, DCTest.class, 1000001);

        t1.setParent(t2);

        ec.commitChanges();


all other attributes of the objects get updated except parent/chindren relationship

Any idea ?
Thank you
Amedeo


Reply | Threaded
Open this post in threaded view
|

Re: Issue with same entity relationship

Amedeo Mantica
Forgot to say. Cayenne 3.1.x

Sent from my iPhone

> On 6 May 2017, at 20:07, Amedeo Mantica <[hidden email]> wrote:
>
> Hi all,
>
> I have setup a Table with self entity relationship (let say parent/children)
>
> so in database I have along with other columns:
>
> ID
> PARENT_ID
>
> set with relationship:
>
> <PastedGraphic-1.png>
>
>
> Code:
>
> ObjectContext ec = databaseController.newContext();
>
>         DCTest t1 = Cayenne.objectForPK(ec, DCTest.class, 1000000);
>         DCTest t2 = Cayenne.objectForPK(ec, DCTest.class, 1000001);
>
>         t1.setParent(t2);
>
>         ec.commitChanges();
>
>
> all other attributes of the objects get updated except parent/chindren relationship
>
> Any idea ?
> Thank you
> Amedeo
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Issue with same entity relationship

Amedeo Mantica
I swapped join keys, lol, forget this thread :)

> On 6 May 2017, at 20:29, Amedeo Mantica <[hidden email]> wrote:
>
> Forgot to say. Cayenne 3.1.x
>
> Sent from my iPhone
>
>> On 6 May 2017, at 20:07, Amedeo Mantica <[hidden email]> wrote:
>>
>> Hi all,
>>
>> I have setup a Table with self entity relationship (let say parent/children)
>>
>> so in database I have along with other columns:
>>
>> ID
>> PARENT_ID
>>
>> set with relationship:
>>
>> <PastedGraphic-1.png>
>>
>>
>> Code:
>>
>> ObjectContext ec = databaseController.newContext();
>>
>>        DCTest t1 = Cayenne.objectForPK(ec, DCTest.class, 1000000);
>>        DCTest t2 = Cayenne.objectForPK(ec, DCTest.class, 1000001);
>>
>>        t1.setParent(t2);
>>
>>        ec.commitChanges();
>>
>>
>> all other attributes of the objects get updated except parent/chindren relationship
>>
>> Any idea ?
>> Thank you
>> Amedeo
>>
>>