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