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.
comments powered by Disqus
DbCon provides a simple interface to DBCP, offers distributed pooling configuration and provides a clean layer of separation between Java code and SQL. The project aims to provide: ConnectionPooling (via DBCP) SingletonConnectionPools (connection pools with only one connection) DataSources backed by the same connection pools SqlLibrary for SQL storage available both in a custom format and SqlLibXmlFormat ObjectFacades Corrects for the OracleMetadata foibles PasswordObfuscation Originally develop
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
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
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
A Java-based database connection pooling utility, supporting Time-based expiry, Statement caching, Connection validation, and easy configuration using a pool manager.
jsnap is a standalone server that acts as a middleware between clients that want to execute SQL statements -yet not want to deal with database programming issues like pooling, timeouts, cursors etc.- and database servers. If Java is installed, running jsnap is as easy as running the script sh-server. No other external dependencies, all needed jar's are in the lib/ folder. Development started with JDK 1.5 and is now continuing with 1.6. Though not tested, it probably would work perfectly with 1.4
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.
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.
Everything you need to build a web application on top of Java's standard library: a) Super-easy database pooling. - Create a database pool in one line of code: pool = Db.Pool.mysql(host, port, username, password, dbname); - Take a database connection, 1 line: Db db = pool.take(); - Execute a query with the connection, 1 line. ResultSet rs = db.query("show databases"); - Dispose resources cleanly, 1 line: pool.putBack(db); b) An transactional object cache that automatically adapts to the size of