Re: Many To Many relationships across multiple databases [:|)
Re: Many To Many relationships across multiple databases [:|)
- Subject: Re: Many To Many relationships across multiple databases [:|)
- From: Art Isbell <email@hidden>
- Date: Wed, 26 Feb 2003 09:04:24 -1000
On Wednesday, February 26, 2003, at 08:30 AM, Jonathan Rochkind wrote:
At 03:57 AM 2/26/2003 +0000, Riaz Lalehzari wrote:
I have the the standard tables for a many to many relationship. Eg.
'Driver', 'Car', 'Car-Driver-Join'.
Is it possible to have for example 'Driver' and the Join table on one
database and the 'Car' on the other?
It's supposed to be possible, but I've had trouble getting it to
actually work, even in WO 5.0. Haven't tried with 5.2 yet. I'm
talking about a flattened relationship accross the join table---if
it's not flattened relationship, there's nothing special about the
fact that it spans dbs, and it should most definitely work. It's the
flattened ones I've had trouble with.
That's my experience as well even under WO 5.2. Flattened
relationships generate SQL join statements. When the tables involved
in the join are in different databases, many databases will generate an
error because they don't support joins across tables in different
databases.
I've been able to create a many-to-many relationship across eomodels
by very carefully manually copying the configuration of a many-to-many
relationship created by EOModeler between 2 entities in the same model.
EOModeler won't create a many-to-many relationship across different
eomodels. But I've omitted the flattened relationships and made the
relationships underlying the flattened relationships class properties
when I will be traversing these relationships in my app. Somewhat
clunky, but it works.
Art
http://homepage.mac.com/aisbell/
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.