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

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-4283?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14072227#comment-14072227 ]

Jacques Le Roux commented on OFBIZ-4283:
----------------------------------------

After upgrading to DBCP 2. I think we should consider and review Philippe's patch (even it's not applyable on trunk now). I stumbled upon it while looking for DBCP available patches (it's the only one). I will hopefully do it...

> 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
>              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)