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

Projects:Inclusion Of Apache JDBC Connection Pool In Distribution/Technical Specifications

Contents

Overview

Apache External Connection Pool module is an already existing module first published now 16 months ago (March 2014) which has been matured in production environments proving to be useful because implements the Tomcat JDBC Connection Pool.

Openbravo uses connection pools to reuse existing connections/prepared statements, avoiding the cost of initiating a connection, parsing SQL etc. By default Openbravo uses two different connection pools:

From 3.0PR14Q2 it is possible to specify an external connection provider to replace these two connection pools. Now with this project Openbravo provides an implementation of Tomcat JDBC Connection Pool.

The goal of this project is to include this module within Openbravo 3 distribution including some standard pre-configuration to make easier to use it. More details on how it works can be found in user documentation.

Configuration

The idea of adding this module to the distribution is to enable it by default based on some standard configuration, so everyone installing or updating to 3.0PR15Q4 will automatically take advantage of it. Apache External Connection Pool module configuration is maintained per instance and consists in some new properties in Openbravo.properties file. The full list of configurable properties can be found here.

Bulbgraph.png   The meaning and values of default properties can be found here.

Extended features

In addition to existing features, new capabilities will be implemented within the scope of this project:

Performance considerations

The performance requirement of this project is that the inclusion of the new pool should not significantly degrade performance. It has been done two types of tests:

Closed topics

Retrieved from "http://wiki.openbravo.com/wiki/Projects:Inclusion_Of_Apache_JDBC_Connection_Pool_In_Distribution/Technical_Specifications"

This page has been accessed 1,434 times. This page was last modified on 3 August 2015, at 08:14. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.