Syntax error or access violation with CMP and MySQL

janaudy Nov 17, 2003 3:31 PM

I have this message when creating and entity CMP on jboss 3.2.2:

22:22:34,986 ERROR [User] Could not create entity
java.sql.SQLException: 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(email, firstname, lastname) VALUES ('me@34358.com', 'Thier"

when I call create with "me@34358.com", "Thierry", "LastName".

Any idea on how to track the cause of this problem please?

1. Re: Syntax error or access violation with CMP and MySQL

janaudy Nov 17, 2003 4:15 PM (in response to janaudy)

Stupid me! Do not use "User" as a table name. Guess what? Should have gone to bed earlier!
Thierry @ rugby.mourning
Actions