2 Replies Latest reply on May 21, 2003 5:12 PM by jeffwallen

    Jboss generated SQL: MySQL reports error in syntax

    jeffwallen Newbie

      Whenever I try to deploy an application in jboss I eventually get this exception from MySQL server. I assume that I configured something wrong or someone else would have reported this problem.

      I'm using JBoss 3.0.7 and MySQL 3.23, MySQL-connector 3.0.7

      The follow error occured deploying the gangster-cmp2 app.

      09:53:28,136 WARN [ServiceController] Problem starting service jboss.j2ee:jndiName=crimeportal/Job,service=EJB
      org.jboss.deployment.DeploymentException: Error while creating table; - nested throwable: (java.sql.SQLException: Syntax error o
      r access violation, message from server: "You have an error in your SQL syntax near 'desc VARCHAR(250) BINARY NOT NULL, the_bos
      s INTEGER, CONSTRAINT pk_organization ' at line 1")
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:175)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:84)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:457)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:369)
      at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:198)
      at org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
      at org.jboss.ejb.Container.invoke(Container.java:782)