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
