Commons Dbcp
  1. Commons Dbcp
  2. DBCP-97

setAutoCommit(true) when returning connection to the pool

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: Nightly Builds
    • Fix Version/s: 1.3
    • Labels:
      None
    • Environment:

      Operating System: All
      Platform: All

      Description

      From the Struts user list: [OT] RE: Stackoverflow after DB inactivity
      (MySQL reconnect problem)
      http://www.mail-archive.com/mysql@lists.mysql.com/msg70196.html

      Giving a hint to the database driver that you don't need long running
      transactions makes sense.

      setAutoCommit(true) should be added to PoolableConnectionFactory.passivateObject

        Issue Links

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Dirk Verbeeck
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development