Re: sql for qualifier that spans two databases
Re: sql for qualifier that spans two databases
- Subject: Re: sql for qualifier that spans two databases
- From: "Tonny Staunsbrink" <email@hidden>
- Date: Wed, 18 Jul 2007 20:39:22 +0200
On 7/18/07, Travis Britt <email@hidden> wrote:
Hoping someone can quickly tell me if this should be possible without
writing my own SQL.
Two databases.
Two EOModels, one for each database.
A to-one relationship from an entity in one model to an entity in the
other.
That is no problem unless the target of the releationship i an inheritance hierachy (at least with singetable inheritance and faults it's a problem, I don't know about the other kinds and fetches with fetchspecs).
An EOQualifier is built from a search form that includes attributes
on both entities (each in different models.) The destination key path
is entered as "relationshipName.attributeName."
I haven't tried fetches witch went deep into the model, just fetches on the entities close to the "edge" and fault firing. So can't help you there.
Cheers
/Tonny
The SQL generated for the qualifier references both tables as if they
were in the same DB (this is Oracle 9i using OraclePlugin, WO 5.3.)
Which blows up since of course the tables aren't in the same view/DB.
Thanks!
tb
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/email@hidden
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