Changing jbpm database from HSQL to MySQL causes MySQLSyntaxErrorException on server startup
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.