[JIRA] Created: (CAY-717) Modeler doesn't manage FK constraints with MYSQL

From: Landry Soules (JIRA) ("Landry)
Date: Sat Dec 09 2006 - 17:22:14 EST

Next message: Andrus Adamchik (JIRA): "[JIRA] Created: (CAY-718) ROP: handle non-serializable server side exceptions"

Previous message: Andrus Adamchik: "Proposed Cayenne TLP Resolution"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Modeler doesn't manage FK constraints with MYSQL
------------------------------------------------

         Key: CAY-717
         URL: http://issues.apache.org/cayenne/browse/CAY-717
     Project: Cayenne
        Type: Bug

  Components: CayenneModeler GUI
    Versions: 2.0 [STABLE]
Environment: OS: Kubuntu
DB: MYSQL5
    Reporter: Landry Soules
    Priority: Critical

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>

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/cayenne/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

Next message: Andrus Adamchik (JIRA): "[JIRA] Created: (CAY-718) ROP: handle non-serializable server side exceptions"
Previous message: Andrus Adamchik: "Proposed Cayenne TLP Resolution"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Sat Dec 09 2006 - 17:22:43 EST