• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: MySQL and Generate SQL, and inline bindings problems
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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:
http://www.bignerdranch.com/classes/real-world_webobjects.shtml

 _______________________________________________
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

  • Follow-Ups:
    • Re: MySQL and Generate SQL, and inline bindings problems
      • From: Lachlan Deck <email@hidden>
References: 
 >MySQL and Generate SQL, and inline bindings problems (From: Thomas Worrall <email@hidden>)

  • Prev by Date: Incorrectly Parsed Form Values in WOContext
  • Next by Date: Re: Incorrectly Parsed Form Values in WOContext
  • Previous by thread: MySQL and Generate SQL, and inline bindings problems
  • Next by thread: Re: MySQL and Generate SQL, and inline bindings problems
  • Index(es):
    • Date
    • Thread