From 74a9b4c0583aa664915f658e3ca67988ae4fd245 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期五, 04 三月 2022 21:14:36 +0800
Subject: [PATCH] update 配置增加oracle jdbc链接串
---
ruoyi-admin/src/main/resources/application-dev.yml | 25 +++++++++++++------------
1 files changed, 13 insertions(+), 12 deletions(-)
diff --git a/ruoyi-admin/src/main/resources/application-dev.yml b/ruoyi-admin/src/main/resources/application-dev.yml
index b6f1ec7..0bf7f6d 100644
--- a/ruoyi-admin/src/main/resources/application-dev.yml
+++ b/ruoyi-admin/src/main/resources/application-dev.yml
@@ -9,7 +9,7 @@
# 璁剧疆 Spring Boot Admin Server 鍦板潃
url: http://localhost:9090/admin
instance:
- prefer-ip: true # 娉ㄥ唽瀹炰緥鏃讹紝浼樺厛浣跨敤 IP
+ service-host-type: IP
username: ruoyi
password: 123456
@@ -51,7 +51,7 @@
# 涓诲簱鏁版嵁婧�
master:
driverClassName: com.mysql.cj.jdbc.Driver
- # jdbc 鎵�鏈夊弬鏁伴厤缃弬鑰� com/mysql/cj/conf/PropertyKey
+ # jdbc 鎵�鏈夊弬鏁伴厤缃弬鑰� https://lionli.blog.csdn.net/article/details/122018562
# rewriteBatchedStatements=true 鎵瑰鐞嗕紭鍖� 澶у箙鎻愬崌鎵归噺鎻掑叆鏇存柊鍒犻櫎鎬ц兘(瀵规暟鎹簱鏈夋�ц兘鎹熻�� 浣跨敤鎵归噺鎿嶄綔搴旇�冭檻鎬ц兘闂)
url: jdbc:mysql://localhost:3306/ry-vue?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&rewriteBatchedStatements=true
username: root
@@ -63,6 +63,13 @@
url:
username:
password:
+# oracle:
+# driverClassName: oracle.jdbc.OracleDriver
+# # jdbc 鎵�鏈夊弬鏁伴厤缃弬鑰� https://lionli.blog.csdn.net/article/details/122018562
+# # rewriteBatchedStatements=true 鎵瑰鐞嗕紭鍖� 澶у箙鎻愬崌鎵归噺鎻掑叆鏇存柊鍒犻櫎鎬ц兘(瀵规暟鎹簱鏈夋�ц兘鎹熻�� 浣跨敤鎵归噺鎿嶄綔搴旇�冭檻鎬ц兘闂)
+# url: jdbc:oracle:thin:@//localhost:1521/XE?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&rewriteBatchedStatements=true
+# username: ROOT
+# password: root
druid:
# 鍒濆杩炴帴鏁�
initialSize: 5
@@ -129,9 +136,9 @@
redisson:
# 绾跨▼姹犳暟閲�
- threads: 16
+ threads: 4
# Netty绾跨▼姹犳暟閲�
- nettyThreads: 32
+ nettyThreads: 8
# 浼犺緭妯″紡
transportMode: "NIO"
# 鍗曡妭鐐归厤缃�
@@ -139,9 +146,9 @@
# 瀹㈡埛绔悕绉�
clientName: ${ruoyi.name}
# 鏈�灏忕┖闂茶繛鎺ユ暟
- connectionMinimumIdleSize: 32
+ connectionMinimumIdleSize: 8
# 杩炴帴姹犲ぇ灏�
- connectionPoolSize: 64
+ connectionPoolSize: 32
# 杩炴帴绌洪棽瓒呮椂锛屽崟浣嶏細姣
idleConnectionTimeout: 10000
# 鍛戒护绛夊緟瓒呮椂锛屽崟浣嶏細姣
@@ -150,11 +157,5 @@
retryAttempts: 3
# 鍛戒护閲嶈瘯鍙戦�佹椂闂撮棿闅旓紝鍗曚綅锛氭绉�
retryInterval: 1500
- # 鍙戝竷鍜岃闃呰繛鎺ョ殑鏈�灏忕┖闂茶繛鎺ユ暟
- subscriptionConnectionMinimumIdleSize: 1
# 鍙戝竷鍜岃闃呰繛鎺ユ睜澶у皬
subscriptionConnectionPoolSize: 50
- # 鍗曚釜杩炴帴鏈�澶ц闃呮暟閲�
- subscriptionsPerConnection: 5
- # DNS鐩戞祴鏃堕棿闂撮殧锛屽崟浣嶏細姣
- dnsMonitoringInterval: 5000
--
Gitblit v1.9.3