application-druid.properties
5.76 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
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
#����Դ����
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
# ����
#spring.datasource.druid.master.url=jdbc:mysql://172.16.29.45:3306/hhwmstestks?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8
#spring.datasource.druid.master.url=jdbc:mysql://172.16.29.15:3306/hhwms?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8&autoReconnect=true&failOverReadOnly=false&maxReconnects=9999&initialTimeout=30&rewriteBatchedStatements=true
#spring.datasource.druid.master.username=softhuaheng
#spring.datasource.druid.master.password=HHrobot123.
#spring.datasource.druid.master.url=jdbc:mysql://localhost:3306/hhwms_cs?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8&autoReconnect=true&maxReconnects=9999&initialTimeout=30&rewriteBatchedStatements=true
#spring.datasource.druid.master.username=root
#spring.datasource.druid.master.password=hhsoftware
#spring.datasource.druid.master.url=jdbc:mysql://172.16.29.45:3306/huahengExample?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false
#spring.datasource.druid.master.url=jdbc:mysql://117.62.222.186:3306/wms_v2?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8
spring.datasource.druid.master.url=jdbc:mysql://172.16.2.8:3306/hhwms?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8&autoReconnect=true&maxReconnects=9999&initialTimeout=30&rewriteBatchedStatements=true
spring.datasource.druid.master.username=softhuaheng
spring.datasource.druid.master.password=HHrobot123.
#spring.datasource.druid.master.url=jdbc:mysql://172.16.2.8:3306/hhwmstest?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8&autoReconnect=true&maxReconnects=9999&initialTimeout=30&rewriteBatchedStatements=true
#spring.datasource.druid.master.username=softhuaheng
#spring.datasource.druid.master.password=HHrobot123.
spring.datasource.druid.slave.driverClassName=oracle.jdbc.OracleDriver
spring.datasource.druid.slave.url=jdbc:oracle:thin:@//172.16.2.65:1521/topprd
#spring.datasource.druid.slave.username=dsdemo
#spring.datasource.druid.slave.password=dsdemo
spring.datasource.druid.slave.username=dsdata
spring.datasource.druid.slave.password=dsdata
spring.datasource.druid.check.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
#spring.datasource.druid.check.url=jdbc:sqlserver://172.16.19.63:1433;DatabaseName=\u6606\u5c71\u534e\u6052\u7535\u710a\u673a\u6d4b\u8bd5\u6570\u636e\u5e93;SelectMethod=cursor;encrypt=false;rewriteBatchedStatements=true
spring.datasource.druid.check.url=jdbc:sqlserver://172.16.19.174:1433;DatabaseName=\u6606\u5c71\u534e\u6052\u7535\u710a\u673a\u6d4b\u8bd5\u6570\u636e\u5e93;SelectMethod=cursor;encrypt=false;rewriteBatchedStatements=true
spring.datasource.druid.check.username=sa
spring.datasource.druid.check.password=111988
#spring.datasource.druid.master.username=root
#spring.datasource.druid.master.password=hhsoftware
#spring.datasource.druid.master.username=root
#spring.datasource.druid.master.password=hhsoftware
# �ӿ�
#spring.datasource.druid.slave.open = false
#spring.datasource.druid.slave.url=jdbc:mysql://117.62.222.186:3306/wms_v2?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false
#spring.datasource.druid.slave.username=softhuaheng
#spring.datasource.druid.slave.password=HHrobot123.
#WCS��
#spring.datasource.druid.wcs.url = jdbc:mysql://172.16.2.8:3306/hhwms?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8
#spring.datasource.druid.wcs.username=softhuaheng
#spring.datasource.druid.wcs.password=HHrobot123.
#spring.datasource.druid.wcs.url = jdbc:mysql://172.16.2.8:3306/hhwms?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8
#spring.datasource.druid.wcs.username=softhuaheng
#spring.datasource.druid.wcs.password=HHrobot123.
# 初始化连接数
spring.datasource.druid.initial-size=10
# 最大活动连接数，一个数据库能够支撑最大的连接数是多少呢？
spring.datasource.druid.max-active=80
# 最小空闲连接数，一般设置和initial-size一致
spring.datasource.druid.min-idle=10
# 从连接池获取连接超时时间
spring.datasource.druid.max-wait=30000
# 是否缓存preparedStatement,也是PSCache,oracle适用，mysql下关闭
spring.datasource.druid.pool-prepared-statements=true
spring.datasource.druid.max-pool-prepared-statement-per-connection-size=20
# ���ü����òŽ���һ�μ�⣬�����Ҫ�رյĿ������ӣ���λ�Ǻ���
spring.datasource.druid.timeBetweenEvictionRunsMillis=30000
# ����һ�������ڳ�����С�����ʱ�䣬��λ�Ǻ���
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
#��־����
logging.level.com.huaheng=DEBUG
logging.level.org.springframework=warn
logging.level.spring.springboot.dao=DEBUG
logger.path=D:\\home\\WMSlog