On Oct 3, 2006, at 9:43 AM, John Huss wrote:

I guess I don't know exactly.  Is the WO stack responsible for
generating the sql or the plugin?  My understanding was that WO
generates outer joins with legacy syntax (correctly).  The Frontbase
db server just doesn't interpret it right.  I emailed Frontbase a
while back about it and they acknowledged it and told me to use the
newer join syntax.

Generally, the plugin provides information and services to the JDBC adaptor to generate / tweak the SQL that is generated. See com.webobjects.jdbcadaptor.JDBCPlugIn. Most of the tweaking is done in a subclass of com.webobjects.eoaccess.EOSQLExpression specific to the database. The plugin contains a subclass of EOSQLExpression in which there are methods such as assembleJoinClause(String leftName, String rightName, int semantic) that the plugin can implement to create the correct syntax.

So, to me, this sounds like a defect in the FrontBase plugin.


Chuck

--
Coming in late 2006 - an introduction to web applications using WebObjects and Xcode http://www.global-village.net/wointro

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