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

[Nicolas Malin (Jira)]

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: SVN trunk
            Reporter: Philippe Mouawad


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 is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[Nicolas Malin (Jira)]

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

Philippe Mouawad updated OFBIZ-4283:
------------------------------------

    Attachment: patch-OFBIZ-4283.patch

Patch to:
entity-config.xsd
DBCPConnectionFactory.java

This patch requires:
- commons-dbcp-1.4.jar
- commons-pool-1.5.6.jar

> 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: SVN 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 is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira