| | Druid | DBCP | C3P0 | JBoss | Weblogic |
|---|
| 数据库用户名称 | 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 | | | |
|---|
| 连接池最大使用连接数量 | MaxActive | MaxActive | MaxPoolSize | max-pool-size | MaximumCapacity |
|---|
| 最小逐出时间 | MinEvictableIdleTimeMillis | MinEvictableIdleTimeMillis | | idle-timeout-minutes | InactiveConnectionTimeoutSeconds |
|---|
| 最多等待线程 | MaxWaitThreadCount | MaxWaitThreadCount | | | HighestNumWaiters |
|---|
| 连接池增长步长 | | | AcquireIncrement | | CapacityIncrement |
|---|
| 获取连接时测试是否有效 | TestOnBorrow | TestOnBorrow | TestConnectionOnCheckout | | |
|---|
| 归还连接时是否测试有效 | TestOnReturn | TestOnReturn | TestConnectionOnCheckin | | TestConnectionsOnReserve |
|---|
| 测试有效用的SQL Query | ValidationQuery | ValidationQuery | PreferredTestQuery | check-valid-connection-sql | |
|---|
| 测试有效的超时时间 | ValidationQueryTimeout | ValidationQueryTimeout | | | |
|---|
| 连接初始化SQL | ConnectionInitSqls | ConnectionInitSqls | | new-connection-sql | InitSQL |
|---|
| 连接最大存活实现 | | | MaxConnectionAge | | |
|---|
| 连接泄漏的超时时间 | RemoveAbandonedTimeout | RemoveAbandonedTimeout | UnreturnedConnectionTimeout | | |
|---|
| 关闭泄漏的连接时打印堆栈信息 | LogAbandoned | LogAbandoned | DebugUnreturnedConnectionStackTraces | | |
|---|
| 逐出连接的检测时间间隔 | TimeBetweenEvictionRunsMillis | TimeBetweenEvictionRunsMillis | | | ShrinkFrequencySeconds |
|---|
| Statement缓存算法 | | | | | StatementCacheType | |
|---|
| Statement缓存大小 | MaxPoolPreparedStatementPerConnectionSize | | | prepared-statement-cache-size | StatementCacheSize |
|---|
| 获取连接最大等待时间 | maxWait | maxWait | | blocking-time-millis | |
|---|
| FatalException处理 | ExceptionSorter | | | exception-sorter-class-name | |
|---|
| 调用原生方法检测连接是否有效 | ValidConnectionCheckerClassName | | | valid-connection-checker-class-name | |
|---|
| 检测未关闭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 | | | |
|---|
