• ADADADADAD

    如何使用JDBC连接MySQL 8.x[ mysql数据库 ]

    mysql数据库 时间:2024-11-26 22:16:23

    作者:文/会员上传

    简介:

    MySQL 8.x 新版本JDBC连接方式,旧版本,MySQL Connector/J 5.x 版本的连接方式,MySQL 8.x新版本,MySQL Connector/J 6.x之后 的连接方式,新版mysql驱动的url必须设置时区,即serv

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

    MySQL 8.x 新版本JDBC连接方式,旧版本,MySQL Connector/J 5.x 版本的连接方式,MySQL 8.x新版本,MySQL Connector/J 6.x之后 的连接方式,新版mysql驱动的url必须设置时区,即serverTimezone=UTC,否则会报错。

    1.旧版本,MySQL Connector/J 5.x 版本的连接方式:

    url=jdbc:mysql://localhost:3306/thrcloud_db01?useUnicode=true&characterEncoding=utf8driver-class-name=com.mysql.jdbc.Driver

    2、MySQL 8.x新版本,MySQL Connector/J 6.x之后 的连接方式:

    url=jdbc:mysql://localhost:3306/thrcloud_db01?serverTimezone=UTC&characterEncoding=utf8&useUnicode=true&useSSL=falsedriver-class-name=com.mysql.cj.jdbc.Driver

    注意:新版mysql驱动的url必须设置时区,即serverTimezone=UTC,否则会报如下错误:

    Java.sql.SQLException:Theservertimezonevalue'Öйú±ê׼ʱ¼ä'isunrecognizedorrepresentsmorethanonetimezone.YoumustconfigureeithertheserverorJDBCdriver(viatheserverTimezoneconfigurationproperty)touseamorespecifctimezonevalueifyouwanttoutilizetimezonesupport.atcom.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)~[mysql-connector-java-8.0.14.jar:8.0.14]atcom.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)~[mysql-connector-java-8.0.14.jar:8.0.14]atcom.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)~[mysql-connector-java-8.0.14.jar:8.0.14]atcom.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)~[mysql-connector-java-8.0.14.jar:8.0.14]atcom.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)~[mysql-connector-java-8.0.14.jar:8.0.14]atcom.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76)~[mysql-connector-java-8.0.14.jar:8.0.14]atcom.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835)~[mysql-connector-java-8.0.14.jar:8.0.14]atcom.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:455)~[mysql-connector-java-8.0.14.jar:8.0.14]atcom.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)~[mysql-connector-java-8.0.14.jar:8.0.14]atcom.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)~[mysql-connector-java-8.0.14.jar:8.0.14]atcom.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1464)~[druid-1.0.31.jar:1.0.31]atcom.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1529)~[druid-1.0.31.jar:1.0.31]atcom.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2109)~[druid-1.0.31.jar:1.0.31]Causedby:com.mysql.cj.exceptions.InvalidConnectionAttributeException:Theservertimezonevalue'Öйú±ê׼ʱ¼ä'isunrecognizedorrepresentsmorethanonetimezone.YoumustconfigureeithertheserverorJDBCdriver(viatheserverTimezoneconfigurationproperty)touseamorespecifctimezonevalueifyouwanttoutilizetimezonesupport.atsun.reflect.GeneratedConstructorAccessor29.newInstance(UnknownSource)~[na:na]
    如何使用JDBC连接MySQL 8.x.docx

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

    推荐度:

    下载
    热门标签: JDBCmysql