Re: Design question: are cross database ManyToMany relationships possible

2011-08-08 Thread David Avendasora
Hey Lars, In case you didn't see my earlier email, can you write a SQL Query in any other tool (SequelPRO, DbVisualizer, etc) that will do what you want? If you can, then EOF should be able to do it too. If MySQL won't let you join across DBs on physical servers, then there is little EOF can do

Re: Design question: are cross database ManyToMany relationships possible (Lars Sonchocky-Helldorf)

2011-08-08 Thread Jeffrey Simpson
ubject: Design question: are cross database ManyToMany relationships possible To: WebObjects Development mailto:webobjects-dev@lists.apple.com>> Message-ID: mailto:f37cb22c-694e-418e-9a0a-ed0799b91...@hamburg.de>> Content-Type: text/plain; charset=us-ascii Dear List, I've go

Re: Design question: are cross database ManyToMany relationships possible

2011-08-07 Thread Lars Sonchocky-Helldorf
Am 08.08.2011 um 00:19 schrieb Cail Borrell: > 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. The Dbs are two MySQL DBs on differen

Re: Design question: are cross database ManyToMany relationships possible

2011-08-07 Thread Lars Sonchocky-Helldorf
Am 07.08.2011 um 23:37 schrieb Karl: > I don’t think that we ever really needed to give much thought to that. Its > automatic. Well, so i thought too (in the beginning) but in my case it didn't work in the end. So I conclude, i must have done something what this automatic did not like. Any

Re: Design question: are cross database ManyToMany relationships possible

2011-08-07 Thread Cail Borrell
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 fro

Re: Design question: are cross database ManyToMany relationships possible

2011-08-07 Thread David Avendasora
On Aug 8, 2011, at 5: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? I believe that at the point of cross-DB-anything, you are no longer talking about what WO/EOF can do, you ar

Re: Design question: are cross database ManyToMany relationships possible

2011-08-07 Thread Karl
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? > > > Googlin

Design question: are cross database ManyToMany relationships possible

2011-08-07 Thread Lars Sonchocky-Helldorf
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