[
https://issues.apache.org/jira/browse/DBCP-222?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Phil Steitz resolved DBCP-222.
------------------------------
Resolution: Invalid
Questions such as this should be directed to the commons-user mailing list. I
am closing the issue to keep Jira tidy, but to answer your question, in general
the answer is no, don't count on it, but if you use PoolingConnections with
prepared statement pooling turned on, the PoolingConnection will try to close
the pooled statements in its cache when it is closed.
> Does DBCP closes unclosed PreparedStatement or resultset?
> ---------------------------------------------------------
>
> Key: DBCP-222
> URL: https://issues.apache.org/jira/browse/DBCP-222
> Project: Commons Dbcp
> Issue Type: Bug
> Affects Versions: 1.2.2
> Environment: Windows, Linux
> Reporter: Bill Liu
>
> this is more of a question. I cannot find any doc on the Apache site. Sorry
> if this is not a right place to ask the question.
> We maintain a big web site and there are lots of legacy code where there are
> unclosed preparedstatements / resultsets. Does the DBCP closes these
> forgotten unclosed statements and result sets automatically when an
> connection is returned? Inceasing number of statements and results could slow
> down our database significantly.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
