Re: Error with Cross-Model Relationship
Re: Error with Cross-Model Relationship
- Subject: Re: Error with Cross-Model Relationship
- From: Travis Britt <email@hidden>
- Date: Tue, 2 Dec 2008 10:01:18 -0500
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