Tomcat fails to start with the following error in the application server log:
ERROR org.hibernate.util.JDBCExceptionReporter - 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 'system, url_alias, uuid, version_uuid) values (X, XXXXXXXXXXXX, X, XXXXXXXXXXXX' at line 1
Tomcat will return this error when the environment is using an unsupported version of MySQL.
To check the MySQL version:
C:\Program Files\MySQL\MySQL Server x.x\bin\mysqld.exe -V
Refer to the System Requirements documentation to determine the supported versions of MySQL and upgrade MySQL accordingly.
This article applies to Appian 18.3 and later.
Last Reviewed: October 2018
© 2020 Appian. All rights reserved.