Re: Cayenne Article on TheServerSide.com

From: James Treleaven (jametre..noreo.on.ca)
Date: Thu Jun 10 2004 - 14:42:43 EDT

  • Next message: dan17..elus.net: "aggregate queries"

    Darn! I did suspect it was user error. Thanks Andrus.

    James

    Andrus Adamchik wrote:
    > James,
    >
    > I guess you've overlooked joins dialog in the modeler. See below...
    >
    > On Jun 10, 2004, at 11:26 AM, James Treleaven wrote:
    >
    >> <db-relationship name="toProject" source="member" target="project"
    >> toDependentPK="false" toMany="false">
    >> <db-attribute-pair source="project_id" target="project_id"/>
    >> </db-relationship>
    >>
    >> is equivalent to
    >>
    >> <db-relationship name="toProject" source="member" target="project"
    >> toDependentPK="false" toMany="false">
    >> </db-relationship>
    >
    >
    > No they are not equivalent. The first example has a join, the second
    > does not.
    >
    >
    >> ... and I can see how to generate the later with the modeler.
    >> But I believe I can only generate the following by hand:
    >>
    >> <db-relationship name="toProject" source="member" target="project"
    >> toDependentPK="false" toMany="false">
    >> <db-attribute-pair source="project_id" target="id"/>
    >> </db-relationship>
    >
    >
    > No, you can do this in the modeler (aside from the bug described by
    > Eric, which is fixed already). Select DbRelationship in the modeler, and
    > click "Database Mapping" button in the lower right corner. Add joins in
    > the opened dialog.
    >
    > Andrus
    >
    >



    This archive was generated by hypermail 2.0.0 : Thu Jun 10 2004 - 14:42:35 EDT