application-druid.properties
4.22 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
#����Դ����
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
# ???????
#spring.datasource.druid.master.url=jdbc:mysql://47.106.215.73:3306/wms_ningxiangwanrong?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8
spring.datasource.druid.master.url=jdbc:mysql://localhost:3306/wms_ningxiangwanrong?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8
#spring.datasource.druid.master.url=jdbc:mysql://192.168.2.13:3306/wms_ningxiangwanrong?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8
#spring.datasource.druid.master.url=jdbc:mysql://172.16.43.215:3306/wms_ningxiangwanrong?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8
#spring.datasource.druid.master.username=huaheng
#spring.datasource.druid.master.password=HHrobot123.
# ???????
spring.datasource.druid.master.username=root
# spring.datasource.druid.master.password=HHsoft123.
spring.datasource.druid.master.password=123456
#spring.datasource.druid.master.username=huaheng
#spring.datasource.druid.master.password=HHrobot123.
# ??????
#spring.datasource.druid.master.username=root
#spring.datasource.druid.master.password=123456
# �ӿ�
spring.datasource.druid.slave.open=true
spring.datasource.druid.slave.url=jdbc:sqlserver://192.168.2.15:1433;SelectMethod=Cursor;DatabaseName=UFDATA_555_2022
spring.datasource.druid.slave.username=wr_wms
spring.datasource.druid.slave.password=8863895
spring.datasource.druid.slave.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.datasource.druid.slave2.open=true
spring.datasource.druid.slave2.url=jdbc:sqlserver://192.168.2.15:1433;SelectMethod=Cursor;DatabaseName=UFDATA_555_2022
spring.datasource.druid.slave2.username=wr_wms
spring.datasource.druid.slave2.password=8863895
spring.datasource.druid.slave2.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.datasource.druid.mes.open=true
#spring.datasource.druid.mes.url=jdbc:sqlserver://172.16.29.88:1433;SelectMethod=Cursor;DatabaseName=MESPRO4.0.1
#spring.datasource.druid.mes.username=sa
#spring.datasource.druid.mes.password=1qaz!QAZ
spring.datasource.druid.mes.url=jdbc:sqlserver://192.168.2.11;SelectMethod=Cursor;DatabaseName=MESPRO4.0.1
spring.datasource.druid.mes.username=DingAlarms
spring.datasource.druid.mes.password=DingAlarms
spring.datasource.druid.mes.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
# ��ʼ������
spring.datasource.druid.initial-size=4
# ������ӳ�����,�Ե�ǰCPU������2
spring.datasource.druid.max-active=10
# ��С���ӳ�����
spring.datasource.druid.min-idle=4
# ���û�ȡ���ӵȴ���ʱ��ʱ��
spring.datasource.druid.max-wait=60000
# ��PSCache������ָ��ÿ��������PSCache�Ĵ�С
spring.datasource.druid.pool-prepared-statements=true
spring.datasource.druid.max-pool-prepared-statement-per-connection-size=20
# ���ü����òŽ���һ�μ�⣬�����Ҫ�رյĿ������ӣ���λ�Ǻ���
spring.datasource.druid.timeBetweenEvictionRunsMillis=60000
# ����һ�������ڳ�����С�����ʱ�䣬��λ�Ǻ���
spring.datasource.druid.min-evictable-idle-time-millis=300000
# spring.datasource.druid.validation-query=SELECT 1 FROM DUAL
spring.datasource.druid.validation-query=SELECT *
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