Who can tell we why MySQL generates here an error? I think I have no influence in the table creation for a CMP bean. I need advices how I can debug this.
4:35:51,984 WARN [ServiceController] Problem starting service jboss.j2ee:jndiName=com.sun.j2ee.blueprints.signon.user.ejb.UserLocalHome,service=EJB org.jboss.deployment.DeploymentException: Error while creating table opc_manager; - nested throwable: (java.sql.SQLException: 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 '))' at line 1) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:614) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:210) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:499) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:396) at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:172)
The <primkey-field> was not set.
I have not watched the sever.log file.
There are debug lines containing all SQL statements.