RE: 1:n deletion problem

From: Andrus (andru..bjectstyle.org)
Date: Tue Jan 14 2003 - 22:26:15 EST

  • Next message: Fan, Bill (AP - Australia): "RE: 1:n deletion problem"

    Ok, after looking at the map you sent me I figured it out. PROJECTUSERS
    DbEntity mapping needed some modification.

    1. All its columns (DbAttributes) should be marked as Primary Key

    2. All ObjAttributes in Projectusers ObjEntity should be removed.

    3. DbRelationships *to* PROJECTUSERS must be marked as "To Dep PK". Those
    include:
       - PROJECT.projectusersArray
       - USERS.projectusersArray
       - ROLE.projectusersArray

    This will provide enough info for Cayenne to do the right thing.

    On an unrelated note, AUTO_PK_SUPPORT entity is not needed in the project
    (though the table is needed in the DB). I know, Cayenne will pick it up
    during reverse engineering process, but you can safely delete it.

    Andrus

    At 09:40 PM 1/14/2003 -0500, Andrus wrote:
    >Bill,
    >
    >I just ran a quick test. Everything seems to be working as expected in
    >Cayenne. I couldn't reproduce the behavior you are describing. So I wonder
    >if there is any mapping issues? Could you send me your data map XML file.
    >I will take a look.
    >
    >Andrus



    This archive was generated by hypermail 2.0.0 : Tue Jan 14 2003 - 22:25:17 EST