在连接MySQL的时候报错
一、Mysql安装时设置设置时区与当前电脑系统时区不符。
报错:Could not get 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.
查资料(1)修改:my.ini文件,在[mysqld]下方添加:default-time-zone=’+08:00’。(我修改后没有成功)
(2)在连接数据库语句后加:?serverTimezone=GMT%2B8
我用的是druid链接池,在druid.properties中修改url
修改前:url=jdbc:mysql:///worker
修改后:url=jdbc:mysql:///worker?serverTimezone=GMT%2B8
二、druid版本不正确
修改后又报错:Could not get JDBC Connection; nested exception is java.sql.SQLException: validateConnection false
找了许多资料,最后发现是druid版本太低了,与mysql的版本不匹配,果断从阿里云的仓库服务中下载新的jar包,地址:https://maven.aliyun.com/mvn/search,
最后成功链接到了servlet。