I have an EJB application made on j2ee 1.3 using mysql as a data base.
I am tring to move the aplicatin on Jboss, and afther some reading I realised that Jboss is compatible with J2ee, so I thought that the application does not need to be modified. But there seams to be a problem at the deployment of the .ear : it fails to create a table witch name is a reserved word on mysql. The error that apears in the console is the following :
ERROR [EntityContainer] Starting failed org.jboss.deployment.DeploymentException: Error while creating table Key; - nested throwable: (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 'Key (id VARCHAR(250) BINARY NOT NULL, current INTEGER, CONSTRAI")
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:232)
(the error is sent by the mysql connector)
I figure that the error appears because the absence of quotes near the table name (either mysql or ansi specific quotes). (note: the application works on j2ee 1.3).
Can someone help me?
