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
spring:
datasource:
druid:
#监控统计拦截的filters
filters: stat
web-stat-filter:
enabled: true #是否启用StatFilter默认值true
url-pattern: /*
exclusions: /druid/*,*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico
session-stat-enable: true
session-stat-max-count: 10
stat-view-servlet:
# 是否启用statViewServlet配置
enabled: true
# 访问监控页面
url-pattern: "/druid/*"
# 禁止手动重置监控数据
reset-enable: false
# 设置监控页面的登陆名
login-username: root
# 设置监控页面的登陆密码
login-password: root
allow:
#慢SQL
filter:
stat:
merge-sql: true
slow-sql-millis: 10000
log-slow-sql: true
dynamic:
primary: kingbase
strict: false
druid:
#配置初始化大小/最小/最大
initial-size: 1
min-idle: 1
max-active: 20
#获取连接等待超时时间
max-wait: 60000
#间隔多久进行一次检测,检测需要关闭的空闲连接
time-between-eviction-runs-millis: 60000
#一个连接在池中最小生存的时间
min-evictable-idle-time-millis: 30000
validation-query: SELECT 'x' FROM DUAL
test-while-idle: true
test-on-borrow: false
test-on-return: false
#打开PSCache,并指定每个连接上PSCache的大小。oracle设为true,mysql设为false。分库分表较多推荐设置为false
pool-prepared-statements: false
max-pool-prepared-statement-per-connection-size: 20
filters: stat
datasource:
kingbase:
driver-class-name: com.kingbase8.Driver
url: jdbc:kingbase8://kbq-my-ahpt.cofco.com:54322/my_ahpt?currentSchema=public&zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
schema: public
username: my_ahpt
password: xb!1lpT3!eiFH5vu