Re: Relationships without FK constraints?

From: Joe Baldwin (jfbaldwi..arthlink.net)
Date: Fri Mar 27 2009 - 15:27:11 EDT

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

    I am curious: how are your related-tables managed in a relational
    database without FK's? Is there no RDB perspective in the design?

    On Mar 27, 2009, at 2:33 PM, Joseph Schmidt wrote:

    >
    >> Just reread your question.. Sorry for
    >> misleading. This is true, Cayenne
    >> cannot know about relationships in DB without FKs. So you
    >> have to map them
    >> manually
    > Adding manually is not efficient for most cases (too big databases) :
    > (.
    > (This would not convince users to ditch RoR's ActiveRecord for
    > Cayenne :( ).
    >
    > I added a feature request for this:
    > https://issues.apache.org/jira/browse/CAY-1202
    > since Cayenne could infer these relations if they respect the
    > convention.
    >
    > Thanks,
    > Joseph.
    >
    >
    >
    >

    This archive was generated by hypermail 2.0.0 : Fri Mar 27 2009 - 15:35:21 EDT