Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.4
    • Fix Version/s: 2.0
    • Labels:
      None

      Description

      passivateObject in PoolableConnectionFactory sets autoCommit to true, even if defaultAutoCommit is set to false. This results in two extra db queries for every use of the connection (set false, do work, set true). This creates a significant amount of overhead, even if the connection is never even used.

      I propose it be changed to:

      if(conn.getAutoCommit() != _defaultAutoCommit)
      {
      conn.setAutoCommit(_defaultAutoCommit);
      }

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              orangedog OD
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: