• ADADADADAD

    The server time zone value[ mysql数据库 ]

    mysql数据库 时间:2024-12-24 19:12:01

    作者:文/会员上传

    简介:

    异常描述Exception in thread "main" java.sql.SQLException: The server time zone value '???ú±ê×??±??' is unrecognized or represents more than one time zone.

    以下为本文的正文内容,内容仅供参考!本站为公益性网站,复制本文以及下载DOC文档全部免费。

    异常描述

    Exception in thread "main" 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.


    JDBC连接mysql 用的是.connector.6.0.jar

    问题解决:

    String url = "jdbc:mysql://localhost:3306/zdx?serverTimezone=UTC";

    在url后面加上?serverTimezone=UTC

    如下:

    String url = "jdbc:mysql://localhost:3306/zdx?serverTimezone=UTC";


    提示: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.


    这个问题不算错误,只是友好提示,如果不想要,在6.0的jar里,mysql可以自动加载驱动,

    也即是

    Class.forName("com.mysql.jdbc.Driver");这句话注释掉就不会再出现这个提示。



    The server time zone value.docx

    将本文的Word文档下载到电脑

    推荐度:

    下载
    热门标签: serverzonetime