Commons Dbcp
  1. Commons Dbcp
  2. DBCP-210

Have dbcp close pooled prepared statements after some settable time limit

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.0
    • Labels:
      None

      Description

      The problem is, when poolPreparedStatements is set to true and the database is heavy loaded, the prepared statements are never closed. After some time, as the database contents changes, they become unoptimal. It would be nice to have another parameter telling for how long each statement can be kept open.

        Issue Links

          Activity

          Phil Steitz made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Mark Thomas made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Mark Thomas made changes -
          Link This issue duplicates DBCP-368 [ DBCP-368 ]
          Phil Steitz made changes -
          Fix Version/s 2.0 [ 12313721 ]
          Fix Version/s 1.4 [ 12312615 ]
          Phil Steitz made changes -
          Fix Version/s 1.4 [ 12312615 ]
          Fix Version/s 1.3 [ 12311977 ]
          Phil Steitz made changes -
          Field Original Value New Value
          Fix Version/s 1.3 [ 12311977 ]
          Piotr Kołaczkowski created issue -

            People

            • Assignee:
              Unassigned
              Reporter:
              Piotr Kołaczkowski
            • Votes:
              2 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development