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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
