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

Have dbcp close pooled prepared statements after some settable time limit

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 2.0
    • 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.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              pkolaczk Piotr Kolaczkowski
              Votes:
              2 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: