排版真心费劲,大家凑合看下吧,见谅~
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 |