On Sep 25, 2007, at 7:23 PM, Eric Wagner wrote:

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.

This is one of the less well illuminated corners of EOF. The various plugins are the best source of information.

Chuck

--

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects





_______________________________________________
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