On Sep 25, 2007, at 7:11 AM, Chuck Hill wrote:


On Sep 24, 2007, at 9:01 PM, [EMAIL PROTECTED] wrote:

Good to know and looks like it might fix my problem. Except that MySQL doesn't support WO's syntax for outer joins.

You should be able to correct this by sub-classing com.webobjects.jdbcadaptor.MySQLPlugIn and com.webobjects.jdbcadaptor.MySQLPlugIn.MySQLExpression.

Done and working. Just adapted Project WONDER's postgresql plugin. I'm still not 100% on the join semantics, I had to make it EOLeftOuterJoin for the to-Many relationship and the to-one relationship in the join table for both directions. Does anybody have good documentation as to what the proper usage of the join semantics from an enterprise object perspective and not SQL? Or does that even make sense.

Thanks all for the help.


_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

Reply via email to