各种连接池参数比较

	Druid	DBCP	C3P0	JBoss	Weblogic	BonCP
数据库用户名称	Username	Username	User	user-name
数据库密码	Password	Password	Password	password
驱动名称	DriverClassName	DriverClassName	DriverClass	driver-class	DriverName
JDBC连接串	Url	Url	JdbcUrl	connection-url	Url
JDBC连接属性	Properties	Properties	Properties	connection-property	Properties
初始化大小	InitialSize	InitialSize	InitialPoolSize		Initial Capacity
连接池最小空闲	MinIdle	MinIdle	MinPoolSize	min-pool-size
连接池最大空闲	MaxIdle	MaxIdle	MaxPoolSize	max-pool-size
连接池最大使用连接数量	MaxActive	MaxActive			MaximumCapacity
最小逐出时间	MinEvictableIdleTimeMillis	MinEvictableIdleTimeMillis
最多等待线程	MaxWaitThreadCount	MaxWaitThreadCount			HighestNumWaiters
连接池增长步长			AcquireIncrement		CapacityIncrement
获取连接时测试是否有效	TestOnBorrow	TestOnBorrow	TestConnectionOnCheckout
归还连接时是否测试有效	TestOnReturn	TestOnReturn	TestConnectionOnCheckin		TestConnectionsOnReserve
测试有效用的SQL Query	ValidationQuery	ValidationQuery	PreferredTestQuery
测试有效的超时时间	ValidationQueryTimeout	ValidationQueryTimeout
连接初始化SQL	ConnectionInitSqls	ConnectionInitSqls			InitSQL
连接最大存活实现			MaxConnectionAge
连接泄漏的超时时间	RemoveAbandonedTimeout	RemoveAbandonedTimeout	UnreturnedConnectionTimeout
关闭泄漏的连接时打印堆栈信息	LogAbandoned	LogAbandoned	DebugUnreturnedConnectionStackTraces
逐出连接的检测时间间隔	TimeBetweenEvictionRunsMillis	TimeBetweenEvictionRunsMillis			ShrinkFrequencySeconds
Statement缓存算法					StatementCacheType
Statement缓存大小					StatementCacheSize
					TestTableName
					SecondsToTrustAnIdlePoolConnection
					ConnectionCreationRetryFrequencySeconds
					LoginDelaySeconds
					Profile Connection Usage
					Profile Connection Reservation Wait
					Profile Connection Leak
					Profile Connection Reservation Failed
					Profile Statement Cache Entry
					Profile Statement Usage
					Profile Connection Last Usage
					Profile Connection Multithreaded Usage
					Profile Harvest Frequency Seconds
连接池扩展	Filters				DriverInterceptor
					CredentialMappingEnabled
					InactiveConnectionTimeoutSeconds
					ConnectionReserveTimeoutSeconds
	QueryTimeout				StatementTimeout
连接池关闭时对正在使用连接的处理方式					IgnoreInUseConnectionsEnabled
把连接放到ThreadLocal中					PinnedToThread
关闭“赃”连接（调用过getVendorConnection方法）					RemoveInfectedConnections

转载于:https://blog.51cto.com/7399951/1355244