OFBiz
  1. OFBiz
  2. OFBIZ-4283

DBCPConnectionFactory Configuration and Performance improvements

    Details

    • Type: Improvement Improvement
    • Status: Patch Available
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: SVN trunk
    • Fix Version/s: None
    • 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

      1. patch-OFBIZ-4283.patch
        16 kB
        Philippe Mouawad

        Activity

          People

          • Assignee:
            Unassigned
            Reporter:
            Philippe Mouawad
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:

              Development