数据库连接池移除druid atomikos分布式事务使用com.mysql.cj.jdbc.MysqlXADataSource

SZH

2023-02-23 d9adbadd9fa14cb7174f6167c438a45e8176fd26

 safePlatfrom-out-web/src/main/resources/config/application-out-dev.yaml

@@ -11,31 +11,55 @@
  jta:
    transaction-manager-id: txManager
  datasource:
    type: com.alibaba.druid.pool.xa.DruidXADataSource
    type: com.mysql.cj.jdbc.MysqlXADataSource
    emergency:
      driver-class-name: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://192.168.0.52:3306/safeplatform.emergency.dev?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true
      username: gkhy_dev_out_team
      password: Adsdf675T6AC7yga
      type: com.alibaba.druid.pool.DruidDataSource
      initialSize: 3
      minIdle: 3
      maxActive: 10
      maxWait: 30000
      validationQuery: select 1
      validationQueryTimeout: 10000
      testWhileIdle: true
    goalmanage:
      driver-class-name: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://192.168.0.52:3306/safeplatform.goalmanage.dev?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true
      username: gkhy_dev_out_team
      password: Adsdf675T6AC7yga
      type: com.alibaba.druid.pool.DruidDataSource
      initialSize: 3
      minIdle: 3
      maxActive: 10
      maxWait: 30000
      validationQuery: select 1
      validationQueryTimeout: 10000
      testWhileIdle: true
    incidentmanage:
      driver-class-name: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://192.168.0.52:3306/safeplatform.incidentmanage.dev?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true
      username: gkhy_dev_out_team
      password: Adsdf675T6AC7yga
      type: com.alibaba.druid.pool.DruidDataSource
      initialSize: 3
      minIdle: 3
      maxActive: 10
      maxWait: 30000
      validationQuery: select 1
      validationQueryTimeout: 10000
      testWhileIdle: true
    equipment:
      driver-class-name: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://192.168.0.52:3306/safeplatform.equipment.dev?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true
      username: gkhy_dev_out_team
      password: Adsdf675T6AC7yga
      type: com.alibaba.druid.pool.DruidDataSource
      initialSize: 3
      minIdle: 3
      maxActive: 10
      maxWait: 30000
      validationQuery: select 1
      validationQueryTimeout: 10000
      testWhileIdle: true
  redis:
    host: 192.168.0.52
    port: 6378