使用alibaba的druid数据库连接池错误使用springboot整合mybatis时发生了以下错误2019-01-15 11:51:43.771 error 14656 --- [eate-2056859249] com.alibaba.druid.pool.druiddatasource : create connection sqlexception, url: jdbc:mysql://localhost:3306/hong?useunicode=true&characterencoding=utf-8, errorcode 0, state 01s00
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.
at com.mysql.cj.jdbc.exceptions.sqlerror.createsqlexception(sqlerror.java:129) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.exceptions.sqlerror.createsqlexception(sqlerror.java:97) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.exceptions.sqlerror.createsqlexception(sqlerror.java:89) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.exceptions.sqlerror.createsqlexception(sqlerror.java:63) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.exceptions.sqlerror.createsqlexception(sqlerror.java:73) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.exceptions.sqlexceptionsmapping.translateexception(sqlexceptionsmapping.java:76) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.connectionimpl.createnewio(connectionimpl.java:835) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.connectionimpl.<init>(connectionimpl.java:455) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.connectionimpl.getinstance(connectionimpl.java:240) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.nonregisteringdriver.connect(nonregisteringdriver.java:207) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.alibaba.druid.pool.druidabstractdatasource.createphysicalconnection(druidabstractdatasource.java:1513) ~[druid-1.1.9.jar:1.1.9]
at com.alibaba.druid.pool.druidabstractdatasource.createphysicalconnection(druidabstractdatasource.java:1578) ~[druid-1.1.9.jar:1.1.9]
at com.alibaba.druid.pool.druiddatasource$createconnectionthread.run(druiddatasource.java:2466) ~[druid-1.1.9.jar:1.1.9]
caused by: com.mysql.cj.exceptions.invalidconnectionattributeexception: 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.
at sun.reflect.nativeconstructoraccessorimpl.newinstance0(native method) ~[na:1.8.0_191]
at sun.reflect.nativeconstructoraccessorimpl.newinstance(nativeconstructoraccessorimpl.java:62) ~[na:1.8.0_191]
at sun.reflect.delegatingconstructoraccessorimpl.newinstance(delegatingconstructoraccessorimpl.java:45) ~[na:1.8.0_191]
at java.lang.reflect.constructor.newinstance(constructor.java:423) ~[na:1.8.0_191]
at com.mysql.cj.exceptions.exceptionfactory.createexception(exceptionfactory.java:61) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.exceptions.exceptionfactory.createexception(exceptionfactory.java:85) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.util.timeutil.getcanonicaltimezone(timeutil.java:132) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.protocol.a.nativeprotocol.configuretimezone(nativeprotocol.java:2234) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.protocol.a.nativeprotocol.initserversession(nativeprotocol.java:2258) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.connectionimpl.initializepropsfromserver(connectionimpl.java:1319) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.connectionimpl.connectonetryonly(connectionimpl.java:966) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.connectionimpl.createnewio(connectionimpl.java:825) ~[mysql-connector-java-8.0.13.jar:8.0.13]
... 6 common frames omitted
maven依赖
application的配置在这里我使用的时yml
一开始我以为是驱动和连接池版本的问题，后来全部换成最新版本还是一样报错。
解决最后在发现原来放回的时间格式问题，时间快了8个小时，最后在applicaition配置url后面加servertimezone=gmt就解决了。
以上就是springboot使用alibaba的druid数据库连接池错误如何解决的详细内容。