Hi Mark,
I think he's trying to say that it *should* work, but doesn't, due to a
bug in Castor.
There's more info on this problem at:
http://castor.exolab.org/list-archive/msg09309.html
-Mike
From: Mark Ericson <[EMAIL PROTECTED]>
Date sent: Thu, 16 Aug 2001 09:03:25 -0700
To: [EMAIL PROTECTED]
Send reply to: [EMAIL PROTECTED]
Subject: Re: [castor-dev] Many-Many relationship in OQL
> I'm not sure why you think that OQL can't join two entities with a
> many-to-many relationship?
>
> The fact that Castor implements that through a many-table is an artifact of
> the implementation. The Castor implementation should hide this from the OQL
> query.
>
> - Mark
>
> -----Original Message-----
> From: florian ramillien [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 16, 2001 4:11 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [castor-dev] Many-Many relationship in OQL
>
>
> > In a Many-One relationship, I can do this:
> >
> > select o from DetailClass o
> > where o.parentObject.id = "...."
> >
> > How can I do the similar thing in Many-many?
> >
>
> No, OQL can't join two table through a many-table. There is some post
> about this in the mailing list. There is a limited patch available for
> castor 0.9.3.
>
> Take a look at
> [castor-dev] Problem with bad SQL generation with many-to-many relation
> posted 08/08/01.
>
> Hope this can help,
> Florian Ramillien.
>
> -----------------------------------------------------------
> If you wish to unsubscribe from this mailing, send mail to
> [EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
>
> -----------------------------------------------------------
> If you wish to unsubscribe from this mailing, send mail to
> [EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
--
Mike Bridge <[EMAIL PROTECTED]>
Edmonton, Canada
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
