Changing jbpm database from HSQL to MySQL causes MySQLSyntaxErrorException on server startup

Solution Unverified - Updated -


We changed the default database used by JBoss Enterprise SOA-P server instance from the Hypersonic database to MySQL and having some error messages from JBPM during startup of JBoss

2012-05-29 10:54:54,858 INFO  [org.jboss.internal.soa.esb.dependencies.DatabaseInitializer] (main) Initializing java:/JbpmDS from listed sql files
2012-05-29 10:54:54,868 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Start: name=jboss.esb:service=JBPMDatabaseInitializer state=Create mode=Manual requiredState=Installed
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'generated by default as identity (start with 1), class char(1) not null, NAME_ v' at line 1

Is this a known issue?


  • JBoss Enterprise Service Oriented Architecture Platform (SOA-P)
    • 5.2.0

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In