From d9adbadd9fa14cb7174f6167c438a45e8176fd26 Mon Sep 17 00:00:00 2001 From: SZH <szh_hello@163.com> Date: 星期四, 23 二月 2023 15:22:04 +0800 Subject: [PATCH] 数据库连接池移除druid atomikos分布式事务使用com.mysql.cj.jdbc.MysqlXADataSource --- safePlatfrom-out-web/src/main/resources/config/application-guotai-demo.yaml | 34 +++++++++++++++++++++++++++++----- 1 files changed, 29 insertions(+), 5 deletions(-) diff --git a/safePlatfrom-out-web/src/main/resources/config/application-guotai-demo.yaml b/safePlatfrom-out-web/src/main/resources/config/application-guotai-demo.yaml index ec399cb..726fa5c 100644 --- a/safePlatfrom-out-web/src/main/resources/config/application-guotai-demo.yaml +++ b/safePlatfrom-out-web/src/main/resources/config/application-guotai-demo.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.30.107:43306/safeplatform.emergency.guotai.uat?allowMultiQueries=true&autoReconnect=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true username: gkhy_safeplatform_guotai_out password: a7687@i8a1Sdd - 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.30.107:43306/safeplatform.goalmanage.guotai.uat?allowMultiQueries=true&autoReconnect=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true username: gkhy_safeplatform_guotai_out password: a7687@i8a1Sdd - 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.30.107:43306/safeplatform.incidentmanage.guotai.uat?allowMultiQueries=true&autoReconnect=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true username: gkhy_safeplatform_guotai_out password: a7687@i8a1Sdd - 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.30.107:43306/safeplatform.equipment.guotai.uat?allowMultiQueries=true&autoReconnect=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true username: gkhy_safeplatform_guotai_out password: a7687@i8a1Sdd - 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.30.107 port: 6375 -- Gitblit v1.9.2