Re: Problem with DB schema generation

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu Dec 07 2006 - 16:46:33 EST

  • Next message: Lachlan Deck: "Unknown code CayenneRuntimeException help..."

    I emailed Apache infrastructure list. Hopefully it will be back up soon.

    Andrus

    On Dec 7, 2006, at 11:40 PM, Landry Soules wrote:

    > OK, i will but for the moment the link is not accessible...
    >
    > Andrus Adamchik a écrit :
    >> 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 - 16:47:05 EST