Unable to Configure MySQL for CROWDID
Symptoms
Connection of MySQL for CROWDID fails.
The following appears in the logs:
2014-02-09 17:36:56,959 localhost-startStop-1 ERROR [hibernate.tool.hbm2ddl.SchemaUpdate] 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 'type=InnoDB' at line 3
Cause
Since version 5.5, MySQL changed the syntax of TYPE=INNODB to ENGINE=INNODB.
Resolution
In crowd-openidserver-webapp\WEB-INF\classes\jdbc.properties the setting you are currently having is:
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialectYou need to change that to:
hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.