Com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx

has been using Oracle, long time no use of MySQL, today built a MySQL web development environment. Unexpectedly throws this exception:

Remember that when you create the data, the character set is Utf-8:

CREATE DATABASE service DEFAULT CHARACTER SET UTF8;

Online Search for various solutions:

The end result is due to the MySQL driver version:

<dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

<version>5.1.35</version>

</dependency>

Into

<dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

<version>5.1.18</version>

</dependency>

The result is no,

Replace the following Maven dependency problem resolution,

<dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

<version>5.1.6</version>

</dependency>

A dead man.

Com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx