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

Clear PreparedStatement pool when connection is returned to the pool

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.8.0
    • Labels:
      None

      Description

      With the current configuration option poolPreparedStatements true the statements are held open for the lifetime of the connection. This results in cursors being open and locks in the database for a long time, which could cause problems with administrative tasks in the database.

      There should be an additional configuration clearStatementPoolOnReturn. When set to true, the pool will be cleared and the statements closed when the connection is returned to the pool. Default can be false to retain the current behaviour.

      With this the application can still benefit from the Statement-cache in mass operations.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              robpas Robert Paschek
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 2h 20m
                2h 20m