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