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

setAutoCommit(true) when returning connection to the pool

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment