Re: Design question: are cross database ManyToMany relationships possible
Re: Design question: are cross database ManyToMany relationships possible
- Subject: Re: Design question: are cross database ManyToMany relationships possible
- From: Cail Borrell <email@hidden>
- Date: Mon, 08 Aug 2011 00:19:21 +0200
Hi Lars,
Like Karl said it should pretty much just work.
As long as you do not flatten such relationships and also make sure your qualifiers on either side do not include predicates from the other.
In short you just need to keep in mind that EOF will generate SQL that tries to join tables from different databases.
-Cail
On 07/08/2011, at 23.37, Karl wrote:
> I don’t think that we ever really needed to give much thought to that. Its automatic.
>
> Karl
>
> On 2011-08-08, at 12:19 AM, Lars Sonchocky-Helldorf wrote:
>
>> Dear List,
>>
>>
>> I've got a design question: Is it possible to manage cross database ManyToMany relationships with EOF?
>>
>>
>> Googling the topic brought up:
>>
>> http://lists.apple.com/archives/webobjects-dev/2003/Feb/msg00395.html
>>
>> which gives me the faint hope that such things are possible. But then again almost all of the other search results gave me the impression that this isn't possible.
>>
>>
>> Hence my question to the pros: Are such constructs possible, if so what do I have to pay attention to (Of course I tried and failed before asking this question ;-))? What are the pitfalls?
>>
>> If this is not possible I'd like to know what kind of solutions you use in such situations: duplicate tables (which bear the risk of divergence)?
>>
>>
>> thanks & cheers,
>>
>> Lars _______________________________________________
>> 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
>
> _______________________________________________
> 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
_______________________________________________
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