Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-4843

Consult isPoolable hint before caching prepared statement

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Trivial
    • Resolution: Fixed
    • Affects Version/s: 10.4.2.0, 10.5.3.0, 10.6.2.1, 10.7.1.1
    • Fix Version/s: 10.7.1.1
    • Component/s: Network Client
    • Labels:
      None

      Description

      The Derby JDBC client side statement cache should consult the value of the isPoolable hint before caching prepared statements.

      This will give users the ability to avoid that short-lived prepared statements push out more frequently used prepared statements in the case of a full statement cache.
      The API JavaDoc says that it is up to the cache whether the hint is used or not.

        Attachments

        1. derby-4843-1a-consult_isPoolable.diff
          0.8 kB
          Kristian Waagan
        2. derby-4843-1b-consult_isPoolable.diff
          1 kB
          Kristian Waagan
        3. derby-4843-2a-test_isPoolable.diff
          6 kB
          Kristian Waagan

          Activity

            People

            • Assignee:
              kristwaa Kristian Waagan
              Reporter:
              kristwaa Kristian Waagan
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: