1.报MySQL版本的问题
{ "timestamp": "2019-12-09T14:04:19.605+0000", "status": 500, "error": "Internal Server Error", "message": "nested exception is org.apache.ibatis.exceptions.PersistenceException: \r\n### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is 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.\r\n### The error may exist in file [D:\\WorkSpace\\StudioWorkSpace\\mango\\target\\classes\\com\\louis\\mango\\sqlmap\\SysUserMapper.xml]\r\n### The error may involve com.louis.mango.dao.SysUserMapper.findAllUser\r\n### The error occurred while executing a query\r\n### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is 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.", "path": "/user/findAll" }
解决方法:修改application.properties文件中的MySQL连接
spring.datasource.driverClassName=com.mysql.jdbc.Driver #写成下面的写法,则会报错 #spring.datasource.url=jdbc:mysql://localhost:3306/privilege?characterEncoding=utf-8&allowMultiQueries=true #需修改成如下的版本格式,才不会报错 spring.datasource.url=jdbc:mysql://localhost:3306/privilege?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC spring.datasource.username=root spring.datasource.password=123456
原文:https://www.cnblogs.com/qianshouxiuluo/p/12013757.html