| | Druid | DBCP | C3P0 | JBoss | Weblogic |
|---|
| 數(shù)據(jù)庫用戶名稱 | Username | Username | User | user-name | |
|---|
| 數(shù)據(jù)庫密碼 | Password | Password | Password | password | |
|---|
| 驅(qū)動名稱 | 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 | | | |
|---|
| 連接池最大使用連接數(shù)量 | 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 |
|---|
| 連接最大存活實現(xiàn) | | | MaxConnectionAge | | |
|---|
| 連接泄漏的超時時間 | RemoveAbandonedTimeout | RemoveAbandonedTimeout | UnreturnedConnectionTimeout | | |
|---|
| 關(guān)閉泄漏的連接時打印堆棧信息 | 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 | |
|---|
| 調(diào)用原生方法檢測連接是否有效 | ValidConnectionCheckerClassName | | | valid-connection-checker-class-name | |
|---|
| 檢測未關(guān)閉Statement | 缺省打開，無法配置 | | | track-statements | |
|---|
| | | | | | TestTableName |
|---|
| | | | | | SecondsToTrustAnIdlePoolConnection |
|---|
| | | | | | ConnectionCreationRetryFrequencySeconds |
|---|
| | | | | | LoginDelaySeconds |
|---|
| | | | | | Profile Connection Usage |
|---|
| 獲取連接等待統(tǒng)計 | 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執(zhí)行超時時間 | QueryTimeout | | | | StatementTimeout |
|---|
| 連接池關(guān)閉時對正在使用連接的處理方式 | | | | | IgnoreInUseConnectionsEnabled |
|---|
| 把連接放到ThreadLocal中 | | | | | PinnedToThread |
|---|
| 關(guān)閉“贓”連接（調(diào)用過getVendorConnection方法） | | | | | RemoveInfectedConnections |
|---|
| 類型映射配置 | | | | type-mapping | |
|---|
| 事務(wù)隔離級別 | DefaultTransactionIsolation | DefaultTransactionIsolation | | transaction-isolation | |
|---|
| ReadOnly設(shè)置 | DefaultReadOnly | DefaultReadOnly | | | |
|---|
| AutoCommit設(shè)置 | DefaultAutoCommit | DefaultAutoCommit | | | |
|---|
