Re: Modeler: Reengineer from MySQL Server

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Tue Nov 04 2003 - 10:42:25 EST

  • Next message: Martin Dengler: "cayenne & distributed databases"

    On Nov 4, 2003, at 7:40 AM, Jorge Sopena wrote:

    > Hi Andrus,
    >
    > If I'm not wrong, MySql is supposed to support referential integrity
    > constraints when the tables are of InnoDB type.
    > I checked it in MySql v4.0.x.

    Can't say that I tried it, since my test box still runs 3.23, but this
    is what I read too.

    >
    > Even If you don't define your tables as InnoDB, MySql must save
    > information about foreign keys. Because if you open the schema with
    > the Control Center tool the fields that are foreign keys are
    > identified, although then the referential integrity is not supported.

    > Maybe it's not supported by the driver?

    This is a possibility, cause Cayenne makes an honest attempt to read
    the relationships via JDBC (see the source for
    org.objectstyle.cayenne.access.DbLoader.loadDbRelationships(..))

    Andrus

    This archive was generated by hypermail 2.0.0 : Tue Nov 04 2003 - 10:42:32 EST