Statement Leak occurs when batch update is used.
------------------------------------------------
Key: DBCP-372
URL: https://issues.apache.org/jira/browse/DBCP-372
Project: Commons Dbcp
Issue Type: Bug
Affects Versions: 1.4, 1.3
Environment: Oracle 11g
Reporter: Naozumi Taromaru
Priority: Critical
org.apache.commons.dbcp.PoolablePreparedStatement#passivate()
execute clearBatch().
(DBCP-264)
But this clearBatch() throw SQLException.
(DelegatingStatement#checkOpen() throw SQLException, because _closed is true.)
The result,
the PoolablePreparedStatement doesn't return to pool, and
the PoolablePreparedStatement doesn't execute PreparedStatement#close().
When a lot of data is processed,
in the case of Oracle
* ORA-00604
* ORA-01000
occurs.
Proposal:
"clearBatch();" in passivate() method
changes as follows.
batchAdded = false;
getInnermostDelegate().clearBatch();
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
