RE: 1:n deletion problem

From: Fan, Bill (AP - Australia) ("Fan,)
Date: Wed Jan 15 2003 - 00:23:33 EST

  • Next message: Michael Schuldt: "To Dep PK?"

    Andrus & Craig,

    Bingo! It works! Thanks so much for your help!!

    I can't remember why I removed the combined PK setting for PROJECTUSERS
    table at some staging...dump!

    Bill

    -----Original Message-----
    From: Andrus [mailto:andru..bjectstyle.org]
    Sent: Wednesday, January 15, 2003 1:26 PM
    To: cayenne-use..bjectstyle.org
    Subject: 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 - 23:24:04 EST