Uploaded image for project: 'Commons DBCP'
  1. Commons DBCP
  2. DBCP-97

setAutoCommit(true) when returning connection to the pool

    Details

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

      Operating System: All
      Platform: All

    • Bugzilla Id:
      23293

      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

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: