[
https://issues.apache.org/jira/browse/OFBIZ-4283?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14073036#comment-14073036 ]
Jacopo Cappellato commented on OFBIZ-4283:
------------------------------------------
Jacques, thank you for the reference to this ticket. If you are not already working on it I would like to take care of it since I have just finished the upgrade and I should know how to port these feature. Is it ok?
> 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)