You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Philippe Mouawad (JIRA)" <ji...@apache.org> on 2011/05/14 12:17:47 UTC
[jira] [Created] (OFBIZ-4283) DBCPConnectionFactory Configuration
and Performance improvements
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
[jira] [Updated] (OFBIZ-4283) DBCPConnectionFactory Configuration
and Performance improvements
Posted by "Philippe Mouawad (JIRA)" <ji...@apache.org>.
[ 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