[jira] [Assigned] (OFBIZ-4283) DBCPConnectionFactory Configuration and Performance improvements

["Jacques Le Roux (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OFBIZ-4283?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Le Roux reassigned OFBIZ-4283:
--------------------------------------

    Assignee: Jacques Le Roux

> DBCPConnectionFactory Configuration and Performance improvements
> ----------------------------------------------------------------
>
>                 Key: OFBIZ-4283
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4283
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: Trunk
>            Reporter: Philippe Mouawad
>            Assignee: Jacques Le Roux
>              Labels: PERFORMANCE
>         Attachments: patch-OFBIZ-4283.patch
>
>
> Hello,
> I enhanced DBCPConnectionFactory to provide more configuration options of DBCP:
> - jdbc-properties
> - test-on-borrow
> - test-on-return
> - test-while-idle
> - pool-timeout
> - soft-min-evictable-idle-time-millis
> And to read some existing one like validationQuery called pool-jdbc-test-stmt in Ofbiz XSD.
> I also added PreparedStatement Cache:
> - jdbc-maxOpenPreparedStatements
> These improvement require upgrade to:
> - commons-dbcp-1.4
> - commons-pool-1.5.6
> I also enhanced XSD.
> These enhancement make the JDBC pooling much more stable and fast.
> Regards
> Philippe Mouawad
> http://www.ubik-ingenierie.com



--
This message was sent by Atlassian JIRA
(v6.2#6252)