4 Replies Latest reply on Sep 9, 2002 3:01 PM by Thomas Laresch

    crimeportal example w/ mysql?

    Jacob Kitzman Newbie

      Hey,

      Has anybody tried deploying the crimeportal example with a Mysql datasource?

      I get two of the tables created properly and then:

      23:21:10,670 INFO [GangsterEJB] Created table 'gangster' successfully.
      23:21:10,710 INFO [GangsterEJB] Created table 'gangster_enemies' successfully.
      23:21:11,461 WARN [ServiceController] Problem starting service jboss.j2ee:service=EJB,jndiName=crimeportal/Job
      org.jboss.deployment.DeploymentException: Error while creating table; - nested throwable: (java.sql.SQLException: Syntax error or access violation: You have an error in your SQL syntax near 'desc VARCHAR(255) BINARY NOT NULL, the_boss INTEGER, CONSTRAINT pk_organization ' at line 1)