Re: Problem with DB schema generation

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu Dec 07 2006 - 04:43:50 EST

  • Next message: Tore Halset: "types.xml, psql and oid/bytea"

    This is a bug - Modeler still thinks that MySQL doesn't supports FK
    constraints, just like in the old days... Could you please open a bug
    report?

    http://issues.apache.org/cayenne/

    Andrus

    On Dec 7, 2006, at 12:19 AM, Landry Soules wrote:

    > Hello,
    >
    > I used CayenneModeler to design my tables and classes and would
    > like to generate the corresponding SQL, to update my MySQL
    > database. But unfortunately, the "create FK support" option doesn't
    > make any difference, and no foreign key sql statement is generated.
    > Here is an example of a relation i want to appear in my DB :
    > <db-relationship name="toCountry" source="address"
    > target="country" toMany="false">
    > <db-attribute-pair source="country" target="id"/>
    > </db-relationship>
    > <db-relationship name="toState" source="address" target="state"
    > toMany="false">
    > <db-attribute-pair source="state" target="id"/>
    > </db-relationship>
    >
    > Thank you for your help.
    >

    This archive was generated by hypermail 2.0.0 : Thu Dec 07 2006 - 04:44:19 EST