Werner Guttmann wrote:
can you explain to me and everybody else what alternative strategy could be used to replace the outer joins ? Just being curious here .. ;-.).
Werner
On Fri, 28 May 2004 22:53:58 -0600, Bruce Snyder wrote:
Sam Maloney wrote:
Hi everyone,
I am just wondering if the problem with Castor using outer joins to fetch one-to-many relationship PKs still exists (it seems to), and if there is a work around known yet?
The thread on castor-dev explaining the problem (from 2002) is: http://hypermail.linklord.com/castor-dev.old/2002/Mar/0518.html
Sam,
Great to see you here again. I was just addressing the 4k LOB workaround you contributed. I believe I may be integrating your solution in a slightly altered format very soon.
Unfortunatley, this particular limitation still exists. Care to contribute another patch? ;-) We could sure use the help.
The only solution of which I am aware is multiple queries. Quite a while back I was thinking of offering the option of making Castor perform either OUTER JOINs or multiple queries based on a property.
Bruce
--
perl -e 'print unpack("u30","<0G)[EMAIL PROTECTED]&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'
The Castor Project http://www.castor.org/
Apache Geronimo http://incubator.apache.org/projects/geronimo.html
----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
