在学习mybatis时遇到的一些错误:
1、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.
因为我用来最新的mysql-connector-java-8.0.15.jar驱动包,才报这个错误。
解决方法:将property name=“driver” value=“com.mysql.jdbc.Driver”
改为:property name=“driver” value=“com.mysql.cj.jdbc.Driver”
2、Error querying database. Cause: java.sql.SQLException: The server time zone value ‘Öйú±ê׼ʱ¼ä’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
Cause: java.sql.SQLException: The server time zone value ‘Öйú±ê׼ʱ¼ä’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
原因:需要配置时区,通过“serverTimezone”配置。
解决方法:将url改为:
property name=“url” value=“jdbc:mysql://localhost:3306/test?serverTimezone=GMT%2B8”
注意这里的“serverTimezone=GMT%2B8”,GMT%2B8表示东八区。