[DERBY-4843] Consult isPoolable hint before caching prepared statement

• 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
• Assignee: Kristian Waagan
• Reporter: Kristian Waagan
• Created: 13/Oct/10 11:49
• Updated: 06/Jun/11 10:53
• Resolved: 30/May/11 12:19

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.