• 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: WO 5.2.3 and MySQL
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: WO 5.2.3 and MySQL


  • Subject: Re: WO 5.2.3 and MySQL
  • From: Sam Barnum <email@hidden>
  • Date: Sun, 4 Jul 2004 09:03:09 -0700

The fact that USER is a reserved function means that simple queries don't always fail. Only ones that have USER followed immediately by an open parentheses (like an insert statement)

On Jul 3, 2004, at 7:38 AM, Kieran Kelleher wrote:

Just rename your table USER in your MySQL database and in the table name in the EOModel and that will solve it. "USER" is a reserved word in MySQL ...... actually is a function. MySQL is great. You should use InnoDB tables if you want transaction and journaling integrity.

See more info here............
http://homepage.mac.com/kelleherk/iblog/C711669388/E1751512668/ index.html



________________________________________________________________
Config = OS X 10.3.4 / Java 1.4.2 / WO 5.2.3 / XCode v1.2 / MySQL 4.0.20 / Connector-J 3.0.11
Blog: http://webobjects.webhop.org/



On Jul 3, 2004, at 2:19 AM, kadoudal wrote:

I have been using for training OpenBase, and I got my first actual project to be done with mySQL

I tested the Adaptor switching with one of the Apple WO examples running fine with Openbase
the mySQL database equivalent has been installed easily with EOModeler help (adpator switch)


but on my first INSERT I got a syntax error problem :

Next exception:SQL State:42000 -- error code: 1064 -- msg: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'USER(LAST_NAME,

I found that there should be a space between the table name USER and the first parenthesis ...
but it's generated by the adaptor ! is there any clue but drop mySQL ????


Erwin

"The best proof that there's intelligent life in the universe is that
it hasn't come here." Arthur C. Clarke
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.


References: 
 >WO 5.2.3 and MySQL (From: kadoudal <email@hidden>)
 >Re: WO 5.2.3 and MySQL (From: Kieran Kelleher <email@hidden>)

  • Prev by Date: Re: Any WWDC News
  • Next by Date: Re: Any WWDC News
  • Previous by thread: Re: WO 5.2.3 and MySQL
  • Next by thread: Re: specifying number of rows to fetch
  • Index(es):
    • Date
    • Thread