relationship has no joins warning

From: Mark Fraser (mar..ark100.net)
Date: Fri Aug 28 2009 - 19:59:13 EDT

  • Next message: Andrey Razumovsky: "Re: relationship has no joins warning"

    I am using Cayenne 2.0.4.

    I added a table to my database and then manually added as a dbentity and
    objentity in the modeler.

    When I save the project, I get the Warning:

    DbRelationship <TOURNAMENT_TEMPLATES.toSites> has no joins.

    once for each relationship in the db entity that I manually addecd.

    I am getting this error only on this db entity but I have similar db
    entities that are not getting this error that are set up the same way as
    far as I can tell.

    When I access the object in my application I get SQL that looks like this:

    SELECT DISTINCT t0.ID, t0.LONG_NAME, t0.NAME, t0.ONLINE FROM APP.SITES
    t0, APP.TOURNAMENT_TEMPLATES t1 WHERE AND (t1.id = ?) [bind: 1]

    which obviously results in an SQLException.

    I presume this is related to the problem that results in the warning
    message.

    Can anyone tell me from this information what I may be missing?

    I could reimport my schema into the modeler from scratch but I really
    don't want to do that since I have had to modify the project a lot from
    the imported state.

    Thanks,

    Mark

    This archive was generated by hypermail 2.0.0 : Fri Aug 28 2009 - 20:00:01 EDT