【自用】数据库配置一些问题

最新推荐文章于 2024-03-31 12:32:21 发布

奶酪坏了

最新推荐文章于 2024-03-31 12:32:21 发布

阅读量530

点赞数

文章标签： java 开发语言

本文链接：https://blog.csdn.net/qq_43482651/article/details/125037312

版权

一、druid 连接问题

针对 “discard long time none received connection” 报错

解决：在springboot启动类添加静态代码块：

static {
    System.setProperty("druid.mysql.usePingMethod","false");
}

二、针对数据库驱动类报错

JDK 1.8+驱动类更改：

driver-class-name: com.mysql.cj.jdbc.Driver

三、seata 中 db 和 service 配置

db {
      ## the implement of javax.sql.DataSource, such as DruidDataSource(druid)/BasicDataSource(dbcp)/HikariDataSource(hikari) etc.
      datasource = "druid"
      ## mysql/oracle/postgresql/h2/oceanbase etc.
      dbType = "mysql"
      driverClassName = "com.mysql.cj.jdbc.Driver"
      ## if using mysql to store the data, recommend add rewriteBatchedStatements=true in jdbc connection param
      url = "jdbc:mysql://127.0.0.1:3306/seata?rewriteBatchedStatements=true&serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&useSSL=false"
      user = "root"
      password = "abc123"
      minConn = 5
      maxConn = 100
      globalTable = "global_table"
      branchTable = "branch_table"
      lockTable = "lock_table"
      queryLimit = 100
      maxWait = 5000
    }

service {

  vgroupMapping.fsp_tx_group = "default" #修改自定义事务组名称

  default.grouplist = "127.0.0.1:8091"
  enableDegrade = false
  disable = false
  max.commit.retry.timeout = "-1"
  max.rollback.retry.timeout = "-1"
  disableGlobalTransaction = false
}