在使用springboot整合MYSQL和JPA时项目会报
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.
and
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.
一般出现上述两个问题问题不大嘿嘿 你的连接代码应该是
spring.datasource.url = jdbc:mysql://localhost:3306/test
spring.datasource.driverClassName =com.mysql.jdbc.Driver
在新版spring boot 整合MYSQL和JPA时原来的连接会发生报错需要改成
spring.datasource.url = jdbc:mysql://localhost:3306/test?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf-8
spring.datasource.driverClassName =com.mysql.cj.jdbc.Driver
新版的spring boot Driver 需要写成 com.mysql.cj.jdbc.Driver
指定时区
serverTimezone=GMT%2B8
这段配置时指定时区;上面代码中指定的时区时北京东8区。
serverTimezone=UTC UTC代表全球时区与上面的北京东8区差8个小时
也可以设置成其他时区比如上海: serverTimezone=Asia/Shanghai
指定字符集
useUnicode=true&characterEncoding=utf-8
是否要指定字符集 如果指定字符集就必须让useUnicode等于true
characterEncoding指定字符集位utf-8或者gbk