Re: Problem with objectsWithFetchSpecification
Re: Problem with objectsWithFetchSpecification
- Subject: Re: Problem with objectsWithFetchSpecification
- From: Chuck Hill <email@hidden>
- Date: Thu, 8 Sep 2005 10:39:31 -0700
On Sep 8, 2005, at 12:21 AM, Ian Joyner wrote:
I'm having a strange problem fetching from tables using horizontal
inheritance. I have a hierarchy with Skills_test at the root and
subclasses Graded_test and Value_test. Doing a fetch on
Skills_test, I expect all records in Graded_test and Value_test to
be returned. I see the SQL on the server side and the report "9 row
(s) processed, but get nothing on the server side:
NSArray /*[Skills_test]*/ tests = editingContext
().objectsWithFetchSpecification (new EOFetchSpecification
("Skills_test", null, null));
System.out.println (".load_test_tree tt " + tests.count ());
Suspecting deep fetching,
It should be deep by default.
Sanity check: are there any PK values duplicated between the
Graded_test and Value_test tables?
Tool Curiosity: What is /*[Skills_test]*/ for. Looks like you are
using some sort of tool.
I changed this to just fetch on Graded_test:
NSArray /*[Skills_test]*/ tests = editingContext
().objectsWithFetchSpecification (new EOFetchSpecification
("Graded_test", null, null));
System.out.println (".load_test_tree tt " + tests.count ());
again seeing that fetches are made to the database, but nothing
actually returned.
I then changed the fetch spec to retrieve any other table in the
database and I get the correct number of rows returned, so it seems
to be something weird with the Skills_test hierarchy. Can anyone
give a clue as to why this code is returning records from every
other table in the database except the ones I want? I'm sure it's
something strange in the model (parents are set correctly, abstract
is only on for Skills_test), but have not been able to pinpoint
what the problem is.
That is a hard one. Have you specified restricting qualifiers on the
entity in the EOModel that do not match what is in the DB? I can't
think of anything else. I'll ruminate on it for a while.
Chuck
--
Practical WebObjects - a book for intermediate WebObjects developers
who want to increase their overall knowledge of WebObjects, or those
who are trying to solve specific application development problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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