• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Single Table inheritance and EM question
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Single Table inheritance and EM question


  • Subject: Re: Single Table inheritance and EM question
  • From: William Hatch <email@hidden>
  • Date: Wed, 20 Aug 2008 13:06:49 -0400


On Aug 20, 2008, at 12:15 PM, Mike Schrag wrote:

Fetches to one are resulting in generated sql to all three types, as if I'm fetching on the abstract parent, which I'm not.
Is this fetching to one of these from a completely separate entity, or fetching to-one from its reflexive relationship? Is this the same problem that someone else ran into a couple days ago with relationships from subtypes to the base class of another entity (guido mentioned something about ERAttachment here that I never saw?).

I have an abstract parent Summary, with three concrete sub types; HourSummary, DaySummary, MonthSummary. Month has (optional) a to-many to Day, which in turn has (optional) a to-many to Hour. None of these should be getting tripped right now and are not prefetched. So, if I fetch say HourSummary's, I see three sql selects for Hour, Day and Month. It's almost as if the qualifying attribute is being ignored, although each sql statement has it in the where clause matching what I defined in the model in the Basic tab, Qualifier field (see original post) So one fetch to a specific Entity results in sql selects for all three, with result sets coming back from all three. Ouch;-) At least it's fast. Thanks Mike


Bill


ms

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden

_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
  • Follow-Ups:
    • Re: Single Table inheritance and EM question
      • From: Chuck Hill <email@hidden>
References: 
 >Single Table inheritance and EM question (From: William Hatch <email@hidden>)
 >Re: Single Table inheritance and EM question (From: Mike Schrag <email@hidden>)

  • Prev by Date: Re: Immortal sessions in production
  • Next by Date: Re: Single Table inheritance and EM question
  • Previous by thread: Re: Single Table inheritance and EM question
  • Next by thread: Re: Single Table inheritance and EM question
  • Index(es):
    • Date
    • Thread