Open source database connection pool in Java

Source: Internet
Author: User
Tags connection pooling postgresql set time

Open source database connection pools in Java are available in the following ways:

1, c3p0 c3p0 is an open source JDBC connection pool that is published in the Lib directory with Hibernate, including connection and statement to implement JDBC3 and JDBC2 extension specification descriptions The DataSources object for the pool.

Https://github.com/swaldman/c3p0


2,proxool This is a Java SQL driver driver that provides a connection pooling package for other types of drivers that you choose. Can be ported to existing code very simply. Fully configurable. Fast, mature and robust. You can transparently increase the connection pooling capability for your existing JDBC driver.

http://proxool.sourceforge.net/


3,jakarta DBCP DBCP is a database connection pool that relies on the Jakartacommons-pool object pooling mechanism. DBCP can be used directly in the application.

Http://commons.apache.org/proper/commons-dbcp/index.html


4,ddconnectionbroker Ddconnectionbroker is a simple, lightweight database connection pool.

Http://opensource.devdaily.com/ddConnectionBroker.shtml

Cannot access the


5,dbpool Dbpool is an efficient and easy-to-configure database connection pool. In addition to supporting the functionality that a connection pool should have, it includes an object pool that enables you to develop a database connection pool that meets your own needs.

http://www.snaq.net/java/DBPool/


6,xapool Xapool is an XA database connection pool. It implements the Javax.sql.XADataSource and provides a connection pooling tool.

http://xapool.ow2.org/


7,primrose Primrose is a database connection pool developed by Java. Currently supported containers include tomcat4&5,resin3 and JBOSS3. It also has a standalone version that can be used in the application without having to run in the container. Primrose controls the tracking, configuration, and dynamic pool management of SQL processing through a web interface. In the case of heavy loads, the connection request queue can be processed.

http://www.primrose.org.uk/home.jsp


8,smartpool Smartpool is a connection pool component that mimics the attributes of the application server object pool. Smartpool can resolve some critical issues such as connection leaks (connection leaks), connection blocking, open JDBC objects such as statements,preparedstatements, and so on. The Smartpool features include support for multiple pools, auto-closing of the associated JDBC object, detection of connection leaks after the set time-outs, tracking connection usage, forcing the least recently used connection, and wrapping Smartpool as an existing pool.

http://www.smartpool.com/website/


9,miniconnectionpoolmanager Miniconnectionpoolmanager is a lightweight JDBC database connection pool. It requires only Java1.5 (or higher) and does not rely on third-party packages.

http://www.source-code.biz/miniconnectionpoolmanager/

@@@


10,BONECP BONECP is a fast, open source database connection pool. Help you manage your data connections to give your application faster access to the database. 25 times times faster than the C3P0/DBCP connection pool.

http://jolbox.com/


11,druid, but it's not just a database connection pool, it also contains a proxydriver, a series of built-in JDBC component libraries, and a SQL Parser.

Supports all JDBC-compliant databases, including Oracle, MYSQL, Derby, Postgresql, SQL Server, H2, and more.

The Druid is optimized for Oracle and MySQL, such as Oracle's PS Cache memory footprint optimization and MySQL ping detection optimization.

Druid provides full support for MySQL, Oracle, Postgresql, SQL-92 sql, a handwritten, high-performance SQL Parser that supports visitor mode, making it easy to parse SQL's abstract syntax tree.

Simple SQL statements are less than 10 microseconds, and complex SQL takes 30 microseconds.

SQL parser provided by Druid can be processed at the JDBC layer to intercept SQL, such as sub-database tables, audits, etc. The Wallfilter of Druid Defense of SQL injection attacks is implemented through Druid SQL Parser parsing semantics.

Https://github.com/alibaba/druid


Open source database connection pool in Java

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.