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

Connection validationQuery mechanism should be replaced by new method connection#isValid()

    Details

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

      Description

      Hello,
      Current method of connection validation relies on validationQuery.
      This method has a rather big performance impact on the DB (CPU, for example 3% with SELECT 1 FROM DUAL even with Oracle 10G FAST DUAL) and make an additional query for each borrow (when testOnBorrow is true).
      Wouldn't it be better to use new JDBC 4 method isValid which relies on Driver check ? (Oracle would for example use its internal method ping)

      Thank you
      Philippe
      http://www.ubik-ingenierie.com

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                p.mouawad@ubik-ingenierie.com Philippe Mouawad
              • Votes:
                1 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: