更新mysql5.1.6到mysql8.0.11所遇到的问题
java.sql.SQLSyntaxErrorException: Identifier name ‘myemployees?useunicode=true&characterencoding=utf8&usessl=false&servertimezone=utc’ is too long
需要修改mysql驱动配置:
老版配置mysqljdbc驱动:
数据库连接的基本信息
<property name="driver" value="com.mysql.jdbc.Driver"></property>
<property name="url" value="jdbc:mysql://localhost:3306/mybatisdb"></property>
<property name="username" value="root"></property>
<property name="password" value="root"></property>
新版配置:
<property name="driver" value="com.mysql.cj.jdbc.Driver"></property>
<property name="url" value="jdbc:mysql://localhost:3306/mybatisdb?
useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT"></property>
<property name="user" value="root"></property>
<property name="password" value="root"></property>
注意:在idea下的maven工程中要用转义字符
<property name="jdbcUrl" value="jdbc:mysql://localhost:3306/myemployees?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT"></property>