各连接池配置参数比较

        排版真心费劲，大家凑合看下吧，见谅~

 

	Druid	DBCP	C3P0	Proxool
数据库用户名称	Username	Username	User
数据库密码	Password	Password	Password
驱动名称	DriverClassName	DriverClassName	DriverClass	driver-class
JDBC连接串	Url	Url	JdbcUrl	driver-url
JDBC连接属性	Properties	Properties	Properties
初始化大小	InitialSize	InitialSize	InitialPoolSize
连接池最小空闲	MinIdle	MinIdle	MinPoolSize	minimum-connection-count
连接池最大空闲	MaxIdle	MaxIdle
连接池最大使用连接数量	MaxActive	MaxActive	MaxPoolSize	maximum-connection-count
最小逐出时间	MinEvictableIdle TimeMillis	MinEvictableIdle TimeMillis	maxIdleTime	house-keeping- sleep-time
最多等待线程	MaxWaittdreadCount	MaxWaittdreadCount
连接池增长步长			AcquireIncrement
获取连接时测试是否有效	TestOnBorrow	TestOnBorrow	TestConnection OnCheckout	test-before-use
归还连接时是否测试有效	TestOnReturn	TestOnReturn	TestConnection OnCheckin	test-after-use
连接空闲时测试是否有效	TestWhileIdle	TestWhileIdle
测试有效用的SQL Query	ValidationQuery	ValidationQuery	PreferredTestQuery	house-keeping-test-sql
测试有效的超时时间	ValidationQuery Timeout	ValidationQuery Timeout
连接初始化SQL	ConnectionInitSqls	ConnectionInitSqls
连接最大存活实现			MaxConnectionAge
连接泄漏的超时时间	RemoveAbandoned Timeout	RemoveAbandoned Timeout	Unreturned ConnectionTimeout
关闭泄漏的连接时打印堆栈信息	LogAbandoned	LogAbandoned	DebugUnreturned ConnectionStackTraces
逐出连接的检测时间间隔	TimeBetween EvictionRunsMillis	TimeBetween EvictionRunsMillis	idleConnection TestPeriod
Statement缓存大小	MaxPoolPrepared Statement PerConnectionSize	MaxOpenPrepared Statements	maxStatements
获取连接最大等待时间	maxWait	maxWait
FatalException处理	ExceptionSorter			fatal-sql-exception
调用原生方法检测连接是否有效	ValidConnection CheckerClassName
连接出错时重试次数	ConnectionError RetryAttempts		acquireRetyrAttempts
连接出错时重试N次后退出	breakAfter AcquireFailure		breakAfter AcquireFailure
检测未关闭Statement	缺省打开，无法配置
获取连接等待统计	NotEmptyWait
连接池扩展	Filters
Statement执行超时时间	QueryTimeout
事务隔离级别	DefaultTransaction Isolation	DefaultTransaction Isolation
ReadOnly设置	DefaultReadOnly	DefaultReadOnly
AutoCommit设置	DefaultAutoCommit	DefaultAutoCommit