1 Reply Latest reply on Apr 11, 2006 9:39 AM by urswag

    CMP Entity table create problem

    urswag

      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)