Re: Relationships without FK constraints?

From: Michael Gentry (mgentr..asslight.net)
Date: Fri Mar 27 2009 - 13:04:36 EDT

  • Next message: Joseph Schmidt: "Re: Relationships without FK constraints?"

    I don't reverse engineer often, but I believe if the constraints
    aren't defined in the DB, then the reverse engineering process has no
    way of knowing about the relationship, so you have to go in
    after-the-fact and add it to your model by hand. A little cumbersome,
    but hopefully not too bad (unless you have a huge model).

    mrg

    On Fri, Mar 27, 2009 at 12:59 PM, Joseph Schmidt
    <joseph_schmidt7..ahoo.com> wrote:
    >
    >> I've used Cayenne with a DB that
    >> didn't have FK constraints (the DB
    >> basically only had PK uniqueness constraints).  Worked
    >> fine.
    > Nice. Good to know :).
    >
    >> Just map
    >> things correctly in the modeler.
    > But the Cayenne Modeler doesn't recognize those relationships when reverse engineering the DB, does it?
    >
    > Or am I doing something wrong?
    >
    > Thanks
    > Joseph.
    >
    >
    >
    >
    >
    >



    This archive was generated by hypermail 2.0.0 : Fri Mar 27 2009 - 13:05:09 EDT