Re: To Dep PK and compound keys

From: Tore Halset (halse..vv.ntnu.no)
Date: Fri Mar 05 2004 - 08:40:49 EST

  • Next message: Paul Furbacher: "Re: java.sql.SQLException: Can't obtain connection. Request timed out. Total used connections: 1"

    Sorry, my mistake. Key3 is not part of the primary key of tableB. I
    must have been blind.

      - Tore.

    On Mar 5, 2004, at 14:06, Tore Halset wrote:

    > Hello.
    >
    > I am using cayenne-1.0.6 and have the followin tables
    >
    > tableA<-->>tableB<<-->tableC
    >
    > Here are the primary keys:
    > tableA(key1,key2)
    > tableB(key1,key2,key3)
    > tableC(key3)
    >
    > TableB should get its primary key values from tableA and tableC. I
    > have set the relation from tableC->tableB as "To Dep PK", but the
    > modeler will not let me set the relation from tableA->tableB as "To
    > Dep PK".
    >
    > inserting objects into tableA does not work. cayenne are not able to
    > generate the primary keys.
    >
    > What am I doing wrong here?
    >
    > - Tore.



    This archive was generated by hypermail 2.0.0 : Fri Mar 05 2004 - 08:41:13 EST