db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kristian Waagan (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4843) Consult isPoolable hint before caching prepared statement
Date Wed, 13 Oct 2010 13:15:04 GMT

     [ https://issues.apache.org/jira/browse/DERBY-4843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kristian Waagan updated DERBY-4843:
-----------------------------------

    Attachment: derby-4843-1a-consult_isPoolable.diff

That is correct.
"Regular" statements are initialized with poolable == false, but that doesn't matter for the
internal Derby JDBC client side cache, as it doesn't cache those statements in any case.

Attaching patch 1a, which addresses this issue.
suites.All passed, derbyall still running.

I'll give testing this a few more thoughts...

> Consult isPoolable hint before caching prepared statement
> ---------------------------------------------------------
>
>                 Key: DERBY-4843
>                 URL: https://issues.apache.org/jira/browse/DERBY-4843
>             Project: Derby
>          Issue Type: Improvement
>          Components: Network Client
>    Affects Versions: 10.4.2.0, 10.5.3.0, 10.6.2.1, 10.7.0.0
>            Reporter: Kristian Waagan
>            Assignee: Kristian Waagan
>            Priority: Trivial
>         Attachments: derby-4843-1a-consult_isPoolable.diff
>
>
> 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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message