commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Phil Steitz (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (DBCP-210) Have dbcp close pooled prepared statements after some settable time limit
Date Tue, 24 Feb 2015 03:23:33 GMT

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

Phil Steitz closed DBCP-210.
----------------------------

> Have dbcp close pooled prepared statements after some settable time limit
> -------------------------------------------------------------------------
>
>                 Key: DBCP-210
>                 URL: https://issues.apache.org/jira/browse/DBCP-210
>             Project: Commons Dbcp
>          Issue Type: Improvement
>            Reporter: Piotr Kołaczkowski
>             Fix For: 2.0
>
>
> The problem is, when poolPreparedStatements is set to true and the database is heavy
loaded, the prepared statements are never closed. After some time, as the database contents
changes, they become unoptimal. It would be nice to have another parameter telling for how
long each statement can be kept open. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message