Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-4283

DBCPConnectionFactory Configuration and Performance improvements

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Trunk
    • Fix Version/s: 14.12.01
    • Component/s: framework
    • Labels:

      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

        Attachments

          Activity

            People

            • Assignee:
              jacopoc Jacopo Cappellato
              Reporter:
              p.mouawad@ubik-ingenierie.com Philippe Mouawad
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: