Re: WO 5.2.3 and MySQL
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.