Re: Implement or avoid LEFT JOIN in EOF?
Re: Implement or avoid LEFT JOIN in EOF?
- Subject: Re: Implement or avoid LEFT JOIN in EOF?
- From: Arturo Perez <email@hidden>
- Date: Tue, 20 Sep 2005 11:22:25 -0400
Eugene Khablov wrote:
3. Create pure SQL. It not a WO style...
You could do the setHint thing to put in the SQL you want. It's not
pure EOF but it's better than most of the alternatives you've outlined.
It's also the quickest fix.
6. General solution from topic "EOF Generates Incorrect SQL for Outer Joins
on MySql" from Lee Harvey Osmond was:
Using this aproach we have override not only "assembleJoinClause" from
com.webobjects.eoaccess.EOSQLExpression. Looks like we have to rewrite
"tableListWithRootEntity" to provide the correct JOIN syntax and move a part
of generated by assembleJoinClause condition to tableListWithRootEntity (if
we will have several tables to join). May be someone can share the code if
exists or point to hidden dangers of such implementation?
I did this for the PostgreSQL plugin. I have to warn you that, if you
do it properly, it's an enormous amount of work. IIRC it took me about
10 hours of pure coding time after about a week of studying. The payoff
is a big win for the WO Community and, if you do it, you should put it
up on Project Wonder.
I don't how applicable to MySQL is the PostgreSQL Plugin code.
-arturo
_______________________________________________
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