application-druid.properties
3.32 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
# \u670D\u52A1\u5668
#spring.datasource.druid.master.url=jdbc:mysql://localhost:3306/wms_wuhangelinmei?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8
#spring.datasource.druid.master.username=root
#spring.datasource.druid.master.password=HHsoft123.
# \u963F\u91CC\u4E91
spring.datasource.druid.master.url=jdbc:mysql://10.10.253.188:3306/wms_tianjingelinmei?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8&autoReconnect=true&maxReconnects=9999&initialTimeout=30&rewriteBatchedStatements=true
spring.datasource.druid.master.username=huaheng
spring.datasource.druid.master.password=HHrobot123.
# \u672C\u5730
#spring.datasource.druid.master.url=jdbc:mysql://localhost:3306/wms_wuhangelinmei?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8
#spring.datasource.druid.master.username=root
#spring.datasource.druid.master.password=123456
spring.datasource.druid.mes.url=jdbc:sqlserver://10.2.4.186:1433;DatabaseName=SMES_Production
spring.datasource.druid.mes.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.datasource.druid.mes.username=sa
spring.datasource.druid.mes.password=SQLserver..
# \u521D\u59CB\u8FDE\u63A5\u6570
spring.datasource.druid.initial-size=10
# \u6700\u5C0F\u8FDE\u63A5\u6C60\u6570\u91CF
spring.datasource.druid.min-idle=4
# \u6700\u5927\u8FDE\u63A5\u6C60\u6570\u91CF,\u4EE5\u5F53\u524DCPU\u6838\u6570\u52A02
spring.datasource.druid.max-active=10
# \u914D\u7F6E\u83B7\u53D6\u8FDE\u63A5\u7B49\u5F85\u8D85\u65F6\u7684\u65F6\u95F4
spring.datasource.druid.max-wait=60000
# \u6253\u5F00PSCache\uFF0C\u5E76\u4E14\u6307\u5B9A\u6BCF\u4E2A\u8FDE\u63A5\u4E0APSCache\u7684\u5927\u5C0F
spring.datasource.druid.pool-prepared-statements=true
spring.datasource.druid.max-pool-prepared-statement-per-connection-size=20
# \u914D\u7F6E\u95F4\u9694\u591A\u4E45\u624D\u8FDB\u884C\u4E00\u6B21\u68C0\u6D4B\uFF0C\u68C0\u6D4B\u9700\u8981\u5173\u95ED\u7684\u7A7A\u95F2\u8FDE\u63A5\uFF0C\u5355\u4F4D\u662F\u6BEB\u79D2
spring.datasource.druid.timeBetweenEvictionRunsMillis=60000
# \u914D\u7F6E\u4E00\u4E2A\u8FDE\u63A5\u5728\u6C60\u4E2D\u6700\u5C0F\u751F\u5B58\u7684\u65F6\u95F4\uFF0C\u5355\u4F4D\u662F\u6BEB\u79D2
spring.datasource.druid.min-evictable-idle-time-millis=300000
spring.datasource.druid.validation-query=SELECT 1 FROM DUAL
spring.datasource.druid.test-while-idle=true
spring.datasource.druid.test-on-borrow=false
spring.datasource.druid.test-on-return=false
spring.datasource.druid.stat-view-servlet.enabled=true
spring.datasource.druid.stat-view-servlet.url-pattern=/monitor/druid/*
spring.datasource.druid.filter.stat.log-slow-sql=true
spring.datasource.druid.filter.stat.slow-sql-millis=1000
spring.datasource.druid.filter.stat.merge-sql=false
spring.datasource.druid.filter.wall.config.multi-statement-allow=true
#\u65E5\u5FD7\u914D\u7F6E <DEBUG<INFO<WARN<ERROR<FATAL<OFF
logging.level.com.huaheng=INFO
#mapper\u5C42\u65E5\u5FD7
logging.level.com.huaheng.pc=DEBUG
logging.level.org.springframework=ERROR
logging.level.spring.springboot.dao=ERROR
#\u63A5\u53E3\u8BF7\u6C42\u65E5\u5FD7
logging.level.com.huaheng.framework.aspectj=ERROR
logger.path=D:\\home\\WMSlog