You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@commons.apache.org by "Bill Liu (JIRA)" <ji...@apache.org> on 2007/05/11 02:10:15 UTC
[jira] Created: (DBCP-222) Does DBCP closes unclosed
PreparedStatement or resultset?
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: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org
[jira] Resolved: (DBCP-222) Does DBCP closes unclosed
PreparedStatement or resultset?
Posted by "Phil Steitz (JIRA)" <ji...@apache.org>.
[ 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: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org