• 关于seata启动时连接数据库异常,Mysql版本8.0


    异常报错:

    1. ERROR --- [ionPool-Create-1772825962] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:mysql://127.0.0.1:3306/seata?useUnicode=true&rewriteBatchedStatements=true, errorCode 0, state 08001
    2. ==>
    3. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
    4. at java.base/jdk.internal.reflect.DirectConstructorHandleAccessor.newInstance(DirectConstructorHandleAccessor.java:67)
    5. at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:500)
    6. at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:484)
    7. at com.mysql.jdbc.Util.handleNewInstance(Util.java:389)
    8. at com.mysql.jdbc.Util.getInstance(Util.java:372)
    9. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:958)
    10. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:937)
    11. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
    12. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:872)
    13. at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2316)
    14. at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2069)
    15. at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:794)
    16. at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:44)
    17. at java.base/jdk.internal.reflect.DirectConstructorHandleAccessor.newInstance(DirectConstructorHandleAccessor.java:67)
    18. at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:500)
    19. at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:484)
    20. at com.mysql.jdbc.Util.handleNewInstance(Util.java:389)
    21. at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)
    22. at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325)
    23. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1657)
    24. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1723)
    25. at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2801)
    26. Caused by: java.lang.NullPointerException: Cannot invoke "java.util.Map.get(Object)" because "this.serverVariables" is null
    27. at com.mysql.jdbc.ConnectionImpl.getServerCharset(ConnectionImpl.java:2989)
    28. at com.mysql.jdbc.MysqlIO.sendConnectionAttributes(MysqlIO.java:1873)
    29. at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1802)
    30. at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1206)
    31. at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2239)
    32. at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2270)
    33. ... 12 common frames omitted
    34. <==

    解决:

    1、引入MySQL版本对应的jar包,Seata默认提供了两个版本的,如果没有可自行引入

    2、修改数据库的连接配置

    1. store.db.driverClassName=com.mysql.cj.jdbc.Driver
    2. store.db.url=jdbc:mysql://127.0.0.1:3306/seata?useUnicode=true&rewriteBatchedStatements=true&serverTimezone=GMT%2B8

    seata官方提供的连接默认没有serverTimezone,MySQL8必须得指定一个值,如果是注册到Nacos,可直接修改Nacos中的这两个值即可,改完后重启Seata

  • 相关阅读:
    腾讯出来的3年测试经验小伙来面试,他这情况要求18K我该给吗?
    K8s复习笔记5-镜像构建
    喵 ~ 小程序搭建记录
    探索ChatGPT在提高人脸识别与软性生物识准确性的表现与可解释性
    以其他组件为代价的性能提升不是好提升
    JVM类文件结构
    【广州华锐互动】消防科普VR实训展馆增强群众学习兴趣和沉浸感
    Java实战:SpringBoot集成单点登录CAS
    Python之哈希表-哈希表原理
    webpack使用入门贴
  • 原文地址:https://blog.csdn.net/WXF_Sir/article/details/133646587