Re: Error with Cross-Model Relationship
Re: Error with Cross-Model Relationship
- Subject: Re: Error with Cross-Model Relationship
- From: Chuck Hill <email@hidden>
- Date: Tue, 2 Dec 2008 10:17:44 -0800
On Dec 2, 2008, at 7:35 AM, David Avendasora wrote:
Interesting. Now that you said that I was able to find the thread,
and Mike's message stating almost exactly what you are saying.
http://wiki.objectstyle.org/confluence/display/WOL/mail/524483
It makes complete sense once I read that, but it's so easy to setup
a search UI (especially in D2JC) that allows you to send qualifiers
to both Entities that it isn't really apparent until it starts
failing that it won't work.
I hate to pull this out, but...
I bet there's no way Mike could make cross-database qualifiers work.
Impossible. Certainly not by the weekend, that's for sure.
:-P
That makes three times in 24 hours now!
On Dec 2, 2008, at 10:01 AM, Travis Britt wrote:
On Dec 2, 2008, at 7:21 AM, David Avendasora wrote:
Shouldn't EOF recognize that the tables are in two different
databases and not try to do one select statement that "joins" them?
If I have EntityA in database 1, and EntityA in database 2, and a
relationship between them, and try to do a fetch whose qualifier
crosses the relationship it will fail.
We run into this a lot because we have tables in many different
Oracle schemas.
I think Mike had some ideas about a possible patch for this, but
then again I seem to remember the result was to run away.
Depending on what you're doing you could do two fetches and perform
the join in memory. Or build a view or move data around at the DB
level to more accurately reflect what the app needs.
tb
_______________________________________________
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
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
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