druid连接池常用配置

 

根据项目中用到的druid连接池配置，作了梳理，常用和关键配置项如下表（以oracle）为例：

序	关键配置项	建议取值
1	initial-size	50
2	min-idle	50
3	max-active	100
4	max-wait	60000
5	time-between-eviction-runs-millis	60000
6	validation-query	SELECT   1   FROM    DUAL
7	test-on-borrow	FALSE
8	test-on-return	FALSE
9	test-while-idle	TRUE
10	pool-prepared-statements	TRUE
11	max-pool-prepared-statement-per-connection-size	20
12	validation-query-timeout	10
13	min-evictable-idle-time-millis	300000
14	remove-abandoned	TRUE
15	remove-abandoned-timeout	43200