JDBCpooler

JDBCpooler is a Java library that provides a pool of JDBC connections to a relational database. It allows applications to obtain connections quickly by reusing existing ones, reducing latency and resource consumption incurred by frequent connection creation and teardown. The pool presents a standard DataSource interface, enabling easy integration with typical Java applications and frameworks.

Key features include configurable pool sizing (maximum and minimum idle connections), connection acquisition timeout, idle connection eviction, and connection validation. The pool can automatically test connections before use, detect and recover leaked connections, and report usage statistics. It supports integration with logging and metrics systems and can expose health checks for monitoring.

Architecture and usage: The library comprises a pool manager that maintains a collection of pooled connections and a DataSource facade that applications request connections from. It is designed for thread-safe operation and can be wired into application startup code or configuration scripts. Applications can retrieve connections from JDBCpooler as they would from any DataSource, and release them back to the pool when finished.

Configuration: JDBCpooler can be configured programmatically or via configuration files. Typical properties include jdbc.url, jdbc.driver, jdbc.username, jdbc.password, pool.maxSize, pool.minIdle, pool.connectionTimeout, pool.idleTimeout, and validationQuery. Optional features may include prepared statement caching and custom health checks.

See also: HikariCP, Apache DBCP, C3P0.