Re: MySQL and Generate SQL, and inline bindings problems
Re: MySQL and Generate SQL, and inline bindings problems
- Subject: Re: MySQL and Generate SQL, and inline bindings problems
- From: Guido Neitzer <email@hidden>
- Date: Sun, 5 Oct 2008 23:23:15 -0600
On 05.10.2008, at 17:37, Thomas Worrall wrote: When I go to do Generate SQL for my EOModel, it does not escape the table or field names in backticks (`). Because of this, table names like Order cause SQL errors.
The problem is, that the MySQL plugin doesn't support identifier quoting. The plugin overall is quite rudimentary ... I guess none of the "know suspects" in the Wonder team uses MySQL, so there is not even a Wonder MySQL plugin. Probably because the one from Apple mainly works as long as you deal with the shortcomings. In googling, all I could find was a suggestion to name my tables something else. I can do that, but it seems I shouldn't have to: regardless of what words are reserved, putting them all in backticks would solve the problem entirely. Why doesn't EO do that?
Because nobody in the community bothered creating a new plugin for MySQL when there is an incredibly good and widely supported plugin for PostgreSQL ... and for the cases when people have to or want to use MySQL they use the provided one and live with it.
You can probably build one yourself. It's not too hard, or file a bug report with Apple, maybe they invest some time into that. Second question: I can't get inline bindings to work. My Properties file (in the Resources group) has the following:
# OGNL ognl.active = true ognl.helperFunctions=true ognl.inlineBindings=true
But you are actually linking to WOOgnl.framework, right?
cug
-- Real World WebObjects Bootcamp at the Big Nerd Ranch:
|
_______________________________________________
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