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 ('firstname.lastname@example.org', 'Thier"
when I call create with "email@example.com", "Thierry", "LastName".
Any idea on how to track the cause of this problem please?
Stupid me! Do not use "User" as a table name. Guess what? Should have gone to bed earlier!
Thierry @ rugby.mourning