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")(the error is sent by the mysql connector)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:232)
The problem is now solved, the trick was in standardjbosscmp-jdbc.xml, I had to put the word key at the reserved words.