From d0b97b5655a6cac1efbda08dad1d3019ed973923 Mon Sep 17 00:00:00 2001
From: Lius <Lius2225@163.com>
Date: 星期三, 21 五月 2025 12:04:16 +0800
Subject: [PATCH] 设备日志批量导出
---
lxzn-module-system/lxzn-system-start/src/main/resources/application-dev.yml | 134 ++++++++++++--------------------------------
1 files changed, 38 insertions(+), 96 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 e81ed9d..25cc4fc 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
@@ -1,5 +1,7 @@
锘縮erver:
port: 9999
+# connection-timeout: 80000
+# disableUploadTimeout: false
tomcat:
max-swallow-size: -1
error:
@@ -38,39 +40,19 @@
## quartz瀹氭椂浠诲姟,閲囩敤鏁版嵁搴撴柟寮�
quartz:
job-store-type: jdbc
- initialize-schema: embedded
- #瀹氭椂浠诲姟鍚姩寮�鍏筹紝true-寮� false-鍏�
+ jdbc:
+ initialize-schema: never
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 = ?
- # class: org.springframework.scheduling.quartz.LocalDataSourceJobStore
- # driverDelegateClass: org.quartz.impl.jdbcjobstore.StdJDBCDelegate
- # tablePrefix: QRTZ_
- # isClustered: true
- # misfireThreshold: 12000
- # clusterCheckinInterval: 15000
- 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:
- open-in-view: false
- database-platform: org.hibernate.dialect.SQLServerDialect
+ properties:
+ hibernate:
+ dialect: org.hibernate.dialect.Oracle8iDialect
aop:
proxy-target-class: true
#閰嶇疆freemarker
@@ -95,55 +77,15 @@
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:
- 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_430
-# url: jdbc:sqlserver://localhost:1433;databasename=LXZN_TEST_430
-# url: jdbc:sqlserver://192.168.124.118:1433;databasename=EAM_430_TEST
- username: sa
- password: 123
- driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver
- # 澶氭暟鎹簮閰嶇疆
- #multi-datasource1:
- # url: jdbc:sqlserver://192.168.0.118:1433;databasename=lxzn_test
- # username: sa
- # password: 123
- # driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver
+ driverClassName: dm.jdbc.driver.DmDriver
+ url: jdbc:dm://LOCALHOST:5236/?LXZN_MDC_420&zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
+ username: LXZN_MDC_420
+ password: 123
#redis 閰嶇疆
redis:
database: 0
@@ -237,7 +179,7 @@
enabled: true
#cas鍗曠偣鐧诲綍
cas:
- prefixUrl: http://cas.example.org:8443/cas
+ prefixUrl: http://127.0.0.1:8443/cas
#Mybatis杈撳嚭sql鏃ュ織
logging:
level:
@@ -277,26 +219,26 @@
type: default
prefix: 'demo::'
timeout: 1h
-#绗笁鏂笰PP瀵规帴
-third-app:
- enabled: false
- type:
- #浼佷笟寰俊
- WECHAT_ENTERPRISE:
- enabled: false
- #CORP_ID
- client-id: ??
- #SECRET
- client-secret: ??
- #鑷缓搴旂敤id
- agent-id: ??
- #鑷缓搴旂敤绉橀挜锛堟柊鐗堜紒寰渶瑕侀厤缃級
- # agent-app-secret: ??
- #閽夐拤
- DINGTALK:
- enabled: false
- # appKey
- client-id: ??
- # appSecret
- client-secret: ??
- agent-id: ??
+fileService:
+ host: 127.0.0.1
+ port: 8299
+ username: admin
+ pwd: 123
+ addressToken: /outer/appAuth
+ addressUploadFile: /outer/fileUpload
+ localFilePath: D:/data/sql #鏈湴鏂囦欢璺緞
+ servicePath: D:/data/sql #鐩爣鏂囦欢璺緞
+ logIp: 127.0.0.1
+ logPort: 8888
+ newFilePath: D:/data/bak_sql/ #澶囦唤鍦板潃
+ failedLocFilePath: #澶辫触sql鍦板潃
+webservice:
+ url: http://localhost:8081/services/EquipmentWebService?wsdl
+ namespace: http://service.server.webservice.example.com
+ statusMethod: equipmentStatus
+ rateMethod: equipmentRate
+webservice2:
+ url: 20.10.193.21:9308/webservice/mes/equipment/v1/mdcProcessTask2MEs.asmx?wsdl
+ namespace: http://service.server.webservice.example.com
+ startWorkMethod: equipmentStart
+ endWorkMethod: equipmentEnd
--
Gitblit v1.9.3