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)