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