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

Consult isPoolable hint before caching prepared statement

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Trivial
    • Resolution: Fixed
    • 10.4.2.0, 10.5.3.0, 10.6.2.1, 10.7.1.1
    • 10.7.1.1
    • Network Client
    • 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-2a-test_isPoolable.diff
          6 kB
          Kristian Waagan
        2. derby-4843-1b-consult_isPoolable.diff
          1 kB
          Kristian Waagan
        3. derby-4843-1a-consult_isPoolable.diff
          0.8 kB
          Kristian Waagan

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: