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

Solution Unverified - Updated -

Issue

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?

Environment

  • 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

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content