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

setAutoCommit(true) when returning connection to the pool

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • Nightly Builds
    • 1.3
    • None

    • Operating System: All
      Platform: All

    • 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

          blocks

          Bug - A problem which impairs or prevents the functions of the product. DBCP-102 [dbcp] setReadOnly & setAutoCommit called too many times

          • Major - Major loss of function.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: