[OFBIZ-4283] DBCPConnectionFactory Configuration and Performance improvements

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Trunk
• Fix Version/s: 14.12.01
• Component/s: framework
• Labels: PERFORMANCE
• Assignee: Jacopo Cappellato
• Reporter: Philippe Mouawad
• Created: 14/May/11 10:16
• Updated: 25/Jul/14 13:23
• Resolved: 25/Jul/14 13:22

Description

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