From 5e765b7358c0a1f91b30acf48d442c08073fdbed Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期二, 30 九月 2025 16:06:58 +0800
Subject: [PATCH] 优化数据源配置
---
pipIrr-platform/pipIrr-global/src/main/resources/application-database-ym.yml | 10 +++++++---
1 files changed, 7 insertions(+), 3 deletions(-)
diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-ym.yml b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-ym.yml
index 80e789b..7ebcfe7 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-ym.yml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-ym.yml
@@ -5,9 +5,9 @@
#name: ym
type: com.alibaba.druid.pool.DruidDataSource
driverClassName: com.mysql.cj.jdbc.Driver
- url: jdbc:mysql://192.168.40.166:3306/pipIrr_ym?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull
+# url: jdbc:mysql://192.168.40.166:3306/pipIrr_ym?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull
# url: jdbc:mysql://8.130.130.233:3306/pipIrr_ym?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull
-# url: jdbc:mysql://127.0.0.1:3306/pipIrr_ym?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull
+ url: jdbc:mysql://127.0.0.1:3306/pipIrr_ym?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull
username: root
password: dysql,;.abc!@#
druid:
@@ -45,9 +45,13 @@
#鎸囧畾姣忎釜杩炴帴涓奝SCache鐨勫ぇ灏�
maxPoolPreparedStatementPerConnectionSize: 20
#灞炴�х被鍨嬫槸瀛楃涓诧紝閫氳繃鍒悕鐨勬柟寮忛厤缃墿灞曟彃浠讹紝甯哥敤鐨勬彃浠舵湁锛�
- #鐩戞帶缁熻鐢ㄧ殑filter:stat锛屾棩蹇楃敤鐨刦ilter:log4j锛岄槻寰ql娉ㄥ叆鐨刦ilter:wall
+ #鐩戞帶缁熻鐢ㄧ殑filter:stat锛屽惎鐢ㄦ閰嶇疆锛孞dbcDataSourceStat闈欐�佸彉閲廘inkedHashMap<String, JdbcSqlStat> sqlStatMap鐨凪ap浼氫竴鐩磋鎸佹湁鎵�鏈塖QL涓嶈兘琚獹C閲婃斁锛屽鏄撳唴瀛樻硠闇�
+ #鏃ュ織鐢ㄧ殑filter:log4j锛�
+ #闃插尽sql娉ㄥ叆鐨刦ilter:wall
#filters: stat,wall,config
filters: wall,config
+ #褰� Druid 鏁版嵁婧愶紙DataSource锛夎繖涓� Bean 琚� Spring 瀹瑰櫒閿�姣佹椂锛岄渶瑕佽皟鐢ㄧ殑鏂规硶
+ destroy-method: close
webStatFilter:
# 娣诲姞杩囨护瑙勫垯
urlPattern: /*
--
Gitblit v1.8.0