View source | View content page | Page history | Printable version   

Projects:Connection Pooling Improvements

Contents

Purpose

This project will improve the Openbravo connection pooling:

Technical Notes

Query Timeout

The query timeout can be implemented using JDBC's setQueryTimeout(int seconds) method. For this method to actually work, both the JDBC driver and the DBMS used must support it.

It seems it is properly implemented for Oracle [1], [2]. For postgres it seems that in some versions it is not even implemented [3] and in others the implementation is buggy [4].


[1] http://troyjsd.blogspot.com.es/2012/11/oracle-jdbc-readtimeout-querytimeout.html

[2] https://forums.oracle.com/message/2048172#2048172

[3] https://groups.google.com/forum/#!topic/mybatis-user/TQkSYHL97A8

[4] http://www.postgresql.org/message-id/283FE4ADE0E66642A4301967EDD7BAEE338464@YUL01WMXB02.rp.corp

JDBC Connection Pools Alternatives

Apache DBCP

Home Page

Features:

Hibernate does no longer recommend it: https://forum.hibernate.org/viewtopic.php?f=1&t=947528&view=next

Hibernate Configuration

License: Apache License

C3PO

Home Page

c3p0 is an easy-to-use library for augmenting traditional (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.

Features:

Requisites:

C3P0 Configuration

Hibernate Configuration

License: Eclipse Public License, GNU Library or Lesser General Public License version 2.0 (LGPLv2)

Proxool

Home Page

Features:

Hibernate Configuration

Inactive since 2008.

Licence

DBPool

Home Page

Requisites:

Features:

An example of the pool listener feature is included in the snaq.util.PoolTracer class.

License: DBPool is available under a BSD-style licence as described below. This licence permits redistribution of the binary or source code (or both) for commercial or non-commercial use, provided the licence conditions are followed to acknowledge origination and authorship of the library.

Apache Tomcat Pool

Home Page

Features:

Configuring jdbc-pool for high concurrency

Active

BoneCP

Home Page

Features:

Requirements:

Hibernate Configuration

License: Apache v2

Inactive since 2011

HikariCP

Supports Java 6, 7, and 8.

Features:

Requirements:

Retrieved from "http://wiki.openbravo.com/wiki/Projects:Connection_Pooling_Improvements"

This page has been accessed 7,004 times. This page was last modified on 11 July 2014, at 07:51. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.