1.Unknown initial character set index ‘255’ received from server.Initial client character…
解决:将bean.xml中数据库配置驱动修改如下
<property name="jdbcUrl" value="jdbc:mysql://localhost/dbname"></property>
修改
<property name="jdbcUrl" value="jdbc:mysql://localhost/dbname?useUnicode=true&characterEncoding=utf8"></property>
注意:这个问题在解决问题2后,即提高mysql-connector-java版本后会消失,无需声明编码
2.Unknown system variable 'tx_isolation’
很多人都说提高版本,思路是对的。但是不是随意提高
进入cmd,输入
mysql --version
查看本机mysql版本,之后将pom.xml中的mysql-connector-java配置成相应版本即可
注意:编译器可能会报驱动问题:如下
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'.
The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
此时只要将bean.xml中数据库配置驱动修改如下
<property name="driverClass" value="com.mysql.jdbc.Driver"></property>
替换为
<property name="driverClass" value="com.mysql.cj.jdbc.Driver"></property>
3.The server time zone value ‘�й���ʱ��’ is unrecognized or represents more than one time zone.
在配置连接数据库的URL后面加上?serverTimezone=UTC ,如下:
jdbc:mysql://localhost:3306/dbname?serverTimezone=UTC