1 Reply Latest reply on Nov 17, 2003 4:15 PM by Thierry Janaudy

    Syntax error or access violation with CMP and MySQL

    Thierry Janaudy Newbie

      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?