Return-Path: X-Original-To: apmail-commons-issues-archive@minotaur.apache.org Delivered-To: apmail-commons-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 6304B10970 for ; Tue, 24 Feb 2015 03:23:30 +0000 (UTC) Received: (qmail 71856 invoked by uid 500); 24 Feb 2015 03:23:27 -0000 Delivered-To: apmail-commons-issues-archive@commons.apache.org Received: (qmail 71754 invoked by uid 500); 24 Feb 2015 03:23:27 -0000 Mailing-List: contact issues-help@commons.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: issues@commons.apache.org Delivered-To: mailing list issues@commons.apache.org Received: (qmail 71630 invoked by uid 99); 24 Feb 2015 03:23:27 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 24 Feb 2015 03:23:27 +0000 Date: Tue, 24 Feb 2015 03:23:27 +0000 (UTC) From: "Phil Steitz (JIRA)" To: issues@commons.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Closed] (DBCP-372) Statement Leak occurs when batch update is used. MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DBCP-372?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phil Steitz closed DBCP-372. ---------------------------- > 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.3, 1.4 > Environment: Oracle 11g > Reporter: Naozumi Taromaru > Priority: Critical > Fix For: 1.5.1, 2.0 > > > 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 was sent by Atlassian JIRA (v6.3.4#6332)