Re: Prefetching with inheritance oddity

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu Oct 21 2004 - 22:06:47 EDT

  • Next message: Jorge Sopena: "Re: Weird Behaviour with Nullify rule"

    Confirmed it is a bug -
    http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-218

    Will work on fixing it...

    Andrus

    On Oct 21, 2004, at 1:01 PM, Andrus Adamchik wrote:

    > Derek,
    >
    > this might actually be a bug. Let me investigate this some more...
    >
    > Andrus
    >
    >> I have a Party superclass and Person/Organisation sub classes. I have
    >> relationships set up at both levels. If I create a query based on
    >> person
    >> and prefetch a Person specific relationship, then I get two selects -
    >> one for the person(s) and one for the relationship for those
    >> person(s).
    >> All is well :-)
    >>
    >> However, if I prefetch one of the Party relationships (regardless of
    >> it
    >> being a Party or Person based query), then I get more than two
    >> selects -
    >> one for the person(s), one for the relationship for those person(s),
    >> and then one for each party related to a relationship (fetching the
    >> "Party" object by its id). It looks like that if I use a party
    >> relationship, then it executes a search for every distinct "toParty"
    >> link pointing back from the relationship record(s) to party. Is this
    >> is
    >> a bug or a feature? I would rather not have to push all my
    >> relationships
    >> to the leaf classes if I can help it.
    >>
    >> Thanks
    >>
    >> Derek



    This archive was generated by hypermail 2.0.0 : Thu Oct 21 2004 - 22:06:55 EDT