Vibur DBCP

Vibur DBCP is an open source, free, concurrent, cross-platform, fully-featured and fast command-line software implemented in Java as a JDBC (Java Database Connectivity) connection pool heavily based on Java dynamic proxies.

The program supports statement caching for JDBC Statements (Callable and Prepared), a moderate parameter, SQL queries logging, and provides various configuration examples with Hibernate, Spring, etc.

Features at a glance

Key features include poolFair configuration parameter, which guarantees that no thread will be left aside when accessing the underlying resources of the pool, support for detecting and logging of long active SQL queries, as well as of their concrete parameters, support for detecting and logging of getConnection() method calls that last longer, and support for Hibernate 3.x and 4.x.

Additionally, the software supports validation intervals, intelligent pool sizing, support for retrieving a statement object or raw JDBC connection from a supported proxy object by using the unwrap method of the respective proxy, as well as Java Management Extensions (JMX) support.

It make use of dynamic proxies and standard Java concurrency tool for the build process, and doesn’t require synchronized methods or blocks during standard pool procedures. Vibur DBCP also provides users with detailed records for all active JDBC connections, including stack traces. This function is very useful when the debugging operations lost their connections.

Under the hood and supported operating systems

Looking under the hood of Vibur DBCP, we can notice that it’s a cross-platform software written entirely in the Java programming language. It works with Java 1.6 or later and requires the slf4j/log4j and ConcurrentLinkedHashMap software.

Being written in Java, Vibur DBCP can be used on any operating system where the Java Runtime Environment (JRE) technology is available, including GNU/Linux, Microsoft Windows and Mac OS X. The program runs on 64-bit and 32-bit computers.

What is new in this release:

• Reporting of slow SQL queries now includes the concrete queries parameters.
• Additional work and improvements on JDBC statements caching.
• Various improvements in logging and exceptions handling.

What is new in version 1.0.0:

• Implemented a pool drain (destroying all connections) after a critical SQL server error.
• Allowed for creation of the initial connections in the pool from an existing/external DataSource.
• Made poolReducer optional - config value of 0 disables it.
• Implemented Hibernate4 integration (into a separate project).
• Externalized Hibernate3 integration into a separate project.

Requirements:

• Java 2 Standard Edition Runtime Environment