c3p0
c3p0 is an easy-to-use library for making traditional JDBC drivers "enterprise-ready" by augmenting them with functionality defined by the jdbc3 spec and the optional extensions to jdbc2. It provides (DriverManager-based) JDBC drivers with JNDI-bindable DataSources, including DataSources that implement Connection and Statement Pooling, as described by the jdbc3 spec and jdbc2 std extension.
A connection pool is used to minimize the number of connections opened between application and database. Statement pool stores a partially compiled version of a statement in order to increase performance.
http://www.mchange.com/projects/c3p0/index.html
comments powered by Disqus
Related Products
BoneCP
BoneCP is a fast, Java database connection pool (JDBC Pool) library.
Libzdb - Connection Pool Library in C
Libzdb is a small, fast and easy to use Database Connection Pool Library. It is thread safe and connects to database like MySQL, PostgreSQL, SQLLite and Oracle.
DBPool - Java Database Connection Pooling
A Java-based database connection pooling utility, supporting Time-based expiry, Statement caching, Connection validation, and easy configuration using a pool manager.
SQL Relay - Database Connection Pool library with API available in all programming languages
SQL Relay is a persistent database connection pooling, proxying and load balancing system for Unix and Linux supporting ODBC, and all major databases. It has APIs for C, C++, ODBC, Perl, Perl-DBI, Python, Python-DB, Zope, PHP, Ruby, Ruby-DBI, Java, TCL and Erlang, drop-in replacement libraries for MySQL and PostgreSQL clients.
Proxool
Proxool is a Java connection pool. It transparently adds connection pooling to your existing JDBC driver. The performance of database connections could be monitored. It's easy to configure using the JDBC API, XML, or Java property files. It complies with the J2SE standards.
DBCP
Creating a new connection for each user can be time consuming (often requiring multiple seconds of clock time), in order to perform a database transaction that might take milliseconds. Opening a connection per user can be unfeasible in a publicly-hosted Internet application where the number of simultaneous users can be very large. Accordingly, developers often wish to share a "pool" of open connections between all of the application's current users.
garbage-pools is Common Lisp re-implementation the APR Pools for resource management
garbage-pools is Common Lisp re-implementation the APR Pools for resource management. APIpool The fundamental pool type. with-garbage-pool ((&optional (var '*pool*)) &body body) Performs a series of operations on pool. Return the values returned by the body. Possible use named and unnamed pools. (with-garbage-pool () (cleanup-register myobj clenup-fun))(with-garbage-pool (mypool) (cleanup-register myobj clenup-fun mypool))cleanup-register (object cleanup-fun &optional (pool *pool*)) Register a f
Php-pool - Database connection pooling with PHP and gearman
An experimental connection pooling system using gearman and PHP. more information here: http://gonzalo123.wordpress.com/2010/11/01/database-connection-pooling-with-php-and-gearman/ Simple queries. And a simple error handling: include('../lib/Pool/Client.php');include('../lib/Pool/Server.php');include('../lib/Pool/Exception.php');include('../lib/Pool/Server/Connection.php');include('../lib/Pool/Server/Stmt.php');use Pool\\Client;$conn = Client::singleton()->getConnection(PoolConf::PG1);$sql = "SE
Delphipooling - Pooling objects for Delphi
Arcana provides two OpenSource pooling products to help improve your application's scalability: DataModulePool - This component grew from a need to pool all sorts of database connections and is an offshoot from our original work on the Interbase Pooling Components. The biggest difference is that TDataModulePool pools entire Data Modules. This allows for prepared queries, database connections, or almost any other Delphi component to be pooled. If you are developing a production server and have a
Pool4j - Resource Pools for Java
pool4jA collection of thread safe resource pool implementations for java. Resource pools enable you to share resources across classes and/or threads. Typically resource pools are used when the resource you wish to manage is either expensive to create, or requires a large amount of memory. The most common resource that is pooled is a database connection. Pool4j has several pool implementations that provide you the optimal pooling for whatever resource you need to manage. For a small set of resour