From a83ba191b66e8ab73911c4102c5ffb3aca07a759 Mon Sep 17 00:00:00 2001
From: Lius <Lius2225@163.com>
Date: 星期三, 10 七月 2024 15:10:22 +0800
Subject: [PATCH] sqlserver数据源配置
---
lxzn-module-system/lxzn-system-start/src/main/resources/application-dev.yml | 77 ++++++++++++++++++++++++++++++++------
1 files changed, 64 insertions(+), 13 deletions(-)
diff --git a/lxzn-module-system/lxzn-system-start/src/main/resources/application-dev.yml b/lxzn-module-system/lxzn-system-start/src/main/resources/application-dev.yml
index 72c5c33..ccfdfe0 100644
--- a/lxzn-module-system/lxzn-system-start/src/main/resources/application-dev.yml
+++ b/lxzn-module-system/lxzn-system-start/src/main/resources/application-dev.yml
@@ -38,19 +38,33 @@
## quartz瀹氭椂浠诲姟,閲囩敤鏁版嵁搴撴柟寮�
quartz:
job-store-type: jdbc
- jdbc:
- initialize-schema: never
+ initialize-schema: embedded
+ #瀹氭椂浠诲姟鍚姩寮�鍏筹紝true-寮� false-鍏�
auto-startup: true
+ #寤惰繜1绉掑惎鍔ㄥ畾鏃朵换鍔�
+ startup-delay: 1s
#鍚姩鏃舵洿鏂板繁瀛樺湪鐨凧ob
overwrite-existing-jobs: true
+ properties:
+ org:
+ quartz:
+ scheduler:
+ instanceName: MyScheduler
+ instanceId: AUTO
+ jobStore:
+ selectWithLockSQL: SELECT* FROM {0}LOCKS UPDLOCK WHERE LOCK_NAME = ?
+ threadPool:
+ class: org.quartz.simpl.SimpleThreadPool
+ threadCount: 10
+ threadPriority: 5
+ threadsInheritContextClassLoaderOfInitializingThread: true
#json 鏃堕棿鎴崇粺涓�杞崲
jackson:
date-format: yyyy-MM-dd HH:mm:ss
time-zone: GMT+8
jpa:
- properties:
- hibernate:
- dialect: org.hibernate.dialect.Oracle8iDialect
+ open-in-view: false
+ database-platform: org.hibernate.dialect.SQLServerDialect
aop:
proxy-target-class: true
#閰嶇疆freemarker
@@ -75,15 +89,47 @@
matching-strategy: ant_path_matcher
resource:
static-locations: classpath:/static/,classpath:/public/
-# autoconfigure:
-# exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
+ autoconfigure:
+ exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
datasource:
- type: com.alibaba.druid.pool.DruidDataSource
druid:
- driverClassName: dm.jdbc.driver.DmDriver
- url: jdbc:dm://192.168.124.118:5236/?LXZN_TEST_420&zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
- username: LXZN_TEST_420
- password: LXZN@1688
+ stat-view-servlet:
+ enabled: true
+ loginUsername: admin
+ loginPassword: 123456
+ allow:
+ web-stat-filter:
+ enabled: true
+ dynamic:
+ druid: # 鍏ㄥ眬druid鍙傛暟锛岀粷澶ч儴鍒嗗�煎拰榛樿淇濇寔涓�鑷淬��(鐜板凡鏀寔鐨勫弬鏁板涓�,涓嶆竻妤氬惈涔変笉瑕佷贡璁剧疆)
+ # 杩炴帴姹犵殑閰嶇疆淇℃伅
+ # 鍒濆鍖栧ぇ灏忥紝鏈�灏忥紝鏈�澶�
+ initial-size: 5
+ min-idle: 5
+ maxActive: 20
+ # 閰嶇疆鑾峰彇杩炴帴绛夊緟瓒呮椂鐨勬椂闂�
+ maxWait: 60000
+ # 閰嶇疆闂撮殧澶氫箙鎵嶈繘琛屼竴娆℃娴嬶紝妫�娴嬮渶瑕佸叧闂殑绌洪棽杩炴帴锛屽崟浣嶆槸姣
+ timeBetweenEvictionRunsMillis: 60000
+ # 閰嶇疆涓�涓繛鎺ュ湪姹犱腑鏈�灏忕敓瀛樼殑鏃堕棿锛屽崟浣嶆槸姣
+ minEvictableIdleTimeMillis: 300000
+ validationQuery: SELECT 1
+ testWhileIdle: true
+ testOnBorrow: false
+ testOnReturn: false
+ # 鎵撳紑PSCache锛屽苟涓旀寚瀹氭瘡涓繛鎺ヤ笂PSCache鐨勫ぇ灏�
+ poolPreparedStatements: true
+ maxPoolPreparedStatementPerConnectionSize: 20
+ # 閰嶇疆鐩戞帶缁熻鎷︽埅鐨刦ilters锛屽幓鎺夊悗鐩戞帶鐣岄潰sql鏃犳硶缁熻锛�'wall'鐢ㄤ簬闃茬伀澧�
+ filters: stat,wall,slf4j
+ # 閫氳繃connectProperties灞炴�ф潵鎵撳紑mergeSql鍔熻兘锛涙參SQL璁板綍
+ connectionProperties: druid.stat.mergeSql\=true;druid.stat.slowSqlMillis\=5000
+ datasource:
+ master:
+ url: jdbc:sqlserver://192.168.124.118:1433;databasename=LXZN_TEST_COMMON
+ username: sa
+ password: 123
+ driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver
#redis 閰嶇疆
redis:
database: 0
@@ -115,7 +161,7 @@
# 绛惧悕瀵嗛挜涓�(鍓嶅悗绔涓�鑷达紝姝ｅ紡鍙戝竷璇疯嚜琛屼慨鏀�)
signatureSecret: dd05f1c54d63749eda95f9fa6d49v442a
# 绛惧悕鎷︽埅鎺ュ彛
-# signUrls: /sys/dict/getDictItems/*,/sys/dict/loadDict/*,/sys/dict/loadDictOrderByValue/*,/sys/dict/loadDictItem/*,/sys/dict/loadTreeData,/sys/api/queryTableDictItemsByCode,/sys/api/queryFilterTableDictInfo,/sys/api/queryTableDictByKeys,/sys/api/translateDictFromTable,/sys/api/translateDictFromTableByKeys
+ # signUrls: /sys/dict/getDictItems/*,/sys/dict/loadDict/*,/sys/dict/loadDictOrderByValue/*,/sys/dict/loadDictItem/*,/sys/dict/loadTreeData,/sys/api/queryTableDictItemsByCode,/sys/api/queryFilterTableDictInfo,/sys/api/queryTableDictByKeys,/sys/api/translateDictFromTable,/sys/api/translateDictFromTableByKeys
signUrls: /sys/dict/loadDict/*,/sys/dict/loadDictOrderByValue/*,/sys/dict/loadDictItem/*,/sys/dict/loadTreeData,/sys/api/queryTableDictItemsByCode,/sys/api/queryFilterTableDictInfo,/sys/api/queryTableDictByKeys,/sys/api/translateDictFromTable,/sys/api/translateDictFromTableByKeys
#local銆乵inio銆乤lioss
uploadType: local
@@ -240,3 +286,8 @@
# appSecret
client-secret: ??
agent-id: ??
+webservice:
+ url: http://localhost:8081/services/EquipmentService?wsdl
+ namespace: http://service.server.webservice.example.com
+ statusMethod: equipmentStatus
+ rateMethod: equipmentRate
\ No newline at end of file
--
Gitblit v1.9.3