各种连接池配置参数比较

原文：

	Druid	DBCP	C3P0	JBoss	Weblogic	Proxool
数据库用户名称	Username	Username	User	user-name
数据库密码	Password	Password	Password	password
驱动名称	DriverClassName	DriverClassName	DriverClass	driver-class	DriverName	driver-class
JDBC连接串	Url	Url	JdbcUrl	connection-url	Url	driver-url
JDBC连接属性	Properties	Properties	Properties	connection-property	Properties
初始化大小	InitialSize	InitialSize	InitialPoolSize		Initial Capacity
连接池最小空闲	MinIdle	MinIdle	MinPoolSize	min-pool-size		minimum-connection-count
连接池最大空闲	MaxIdle	MaxIdle
连接池最大使用连接数量	MaxActive	MaxActive	MaxPoolSize	max-pool-size	MaximumCapacity	maximum-connection-count
最小逐出时间	MinEvictableIdleTimeMillis	MinEvictableIdleTimeMillis	maxIdleTime	idle-timeout-minutes	InactiveConnectionTimeoutSeconds	house-keeping-sleep-time
最多等待线程	MaxWaitThreadCount	MaxWaitThreadCount			HighestNumWaiters
连接池增长步长			AcquireIncrement		CapacityIncrement
获取连接时测试是否有效	TestOnBorrow	TestOnBorrow	TestConnectionOnCheckout			test-before-use
归还连接时是否测试有效	TestOnReturn	TestOnReturn	TestConnectionOnCheckin		TestConnectionsOnReserve	test-after-use
连接空闲时测试是否有效	TestWhileIdle	TestWhileIdle
测试有效用的SQL Query	ValidationQuery	ValidationQuery	PreferredTestQuery	check-valid-connection-sql		house-keeping-test-sql
测试有效的超时时间	ValidationQueryTimeout	ValidationQueryTimeout
连接初始化SQL	ConnectionInitSqls	ConnectionInitSqls		new-connection-sql	InitSQL
连接最大存活实现			MaxConnectionAge
连接泄漏的超时时间	RemoveAbandonedTimeout	RemoveAbandonedTimeout	UnreturnedConnectionTimeout
关闭泄漏的连接时打印堆栈信息	LogAbandoned	LogAbandoned	DebugUnreturnedConnectionStackTraces
逐出连接的检测时间间隔	TimeBetweenEvictionRunsMillis	TimeBetweenEvictionRunsMillis	idleConnectionTestPeriod		ShrinkFrequencySeconds
Statement缓存算法					StatementCacheType
Statement缓存大小	MaxPoolPreparedStatementPerConnectionSize	MaxOpenPreparedStatements	maxStatements	prepared-statement-cache-size	StatementCacheSize
获取连接最大等待时间	maxWait	maxWait		blocking-time-millis
FatalException处理	ExceptionSorter			exception-sorter-class-name		fatal-sql-exception
调用原生方法检测连接是否有效	ValidConnectionCheckerClassName			valid-connection-checker-class-name
连接出错时重试次数	ConnectionErrorRetryAttempts		acquireRetyrAttempts
连接出错时重试N次后退出	breakAfterAcquireFailure		breakAfterAcquireFailure
检测未关闭Statement	缺省打开，无法配置			track-statements
					TestTableName
					SecondsToTrustAnIdlePoolConnection
					ConnectionCreationRetryFrequencySeconds
					LoginDelaySeconds
					Profile Connection Usage
获取连接等待统计	NotEmptyWait				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
					ConnectionReserveTimeoutSeconds
Statement执行超时时间	QueryTimeout				StatementTimeout
连接池关闭时对正在使用连接的处理方式					IgnoreInUseConnectionsEnabled
把连接放到ThreadLocal中					PinnedToThread
关闭“赃”连接（调用过getVendorConnection方法）					RemoveInfectedConnections
类型映射配置				type-mapping
事务隔离级别	DefaultTransactionIsolation	DefaultTransactionIsolation		transaction-isolation
ReadOnly设置	DefaultReadOnly	DefaultReadOnly
AutoCommit设置	DefaultAutoCommit	DefaultAutoCommit