View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Add page
Show collection (0 pages)
Collections help

Search

How to Use an External Connection Pool

Bulbgraph.png   The use of external connection pools is available from 3.0PR14Q2

Introduction

By default Openbravo uses two connection pools:

From 3.0MP32 it is possible to specify an external connection provider that Openbravo will use to obtain the JDBC connections. For that, a module containing a subclass of ExternalConnectionPool needs to be installed, and the db.externalPoolClassName property has to be set in Openbravo.properties.

Example: Using the Apache JDBC Connection Pool

The Apache JDBC Connection Pool Openbravo modules provides an implementation of the Apache JDBC Connection Pool.

Once the module has been installed, the db.externalPoolClassName property has to be set in Openbravo.properties. This module implements the external connection pool class in the org.openbravo.apachejdbcconnectionpool.JdbcExternalConnectionPool class, so this line should be added to Openbravo.properties:

db.externalPoolClassName=org.openbravo.apachejdbcconnectionpool.JdbcExternalConnectionPool

This module contains a configuration file template: modules/org.openbravo.apachejdbcconnectionpool/config/connectionPool.properties.template. In order to customize the JDBC connection pool properties this file has to be copied to modules/org.openbravo.apachejdbcconnectionpool/config/connectionPool.properties. The user can then configure the pool properties according to his needs. Hints about how to configure this properties can be found here.

Retrieved from "http://wiki.openbravo.com/wiki/How_to_Use_an_External_Connection_Pool"

This page has been accessed 2,637 times. This page was last modified on 6 May 2014, at 06:03. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.