Return-Path: Delivered-To: apmail-jakarta-commons-user-archive@www.apache.org Received: (qmail 56690 invoked from network); 25 Mar 2006 02:17:23 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 25 Mar 2006 02:17:22 -0000 Received: (qmail 92015 invoked by uid 500); 25 Mar 2006 02:17:19 -0000 Delivered-To: apmail-jakarta-commons-user-archive@jakarta.apache.org Received: (qmail 91963 invoked by uid 500); 25 Mar 2006 02:17:18 -0000 Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Jakarta Commons Users List" Reply-To: "Jakarta Commons Users List" Delivered-To: mailing list commons-user@jakarta.apache.org Received: (qmail 91952 invoked by uid 99); 25 Mar 2006 02:17:18 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 24 Mar 2006 18:17:18 -0800 X-ASF-Spam-Status: No, hits=1.3 required=10.0 tests=RCVD_IN_BL_SPAMCOP_NET,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of sandymac@gmail.com designates 64.233.182.189 as permitted sender) Received: from [64.233.182.189] (HELO nproxy.gmail.com) (64.233.182.189) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 24 Mar 2006 18:17:18 -0800 Received: by nproxy.gmail.com with SMTP id o63so546152nfa for ; Fri, 24 Mar 2006 18:16:56 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=M1J/4YfUbAjtxnQ3xt7XztI5hX+M/DIr+tmiSvonz4NJ50yRl6iWXPeRiscQWz58ALbk5p0IIdwFkwQP43lRj7W85zyRQlmoTT/lN5W2pCnzXNuESo186lcthq46ApTkySn/p+1RTiQEP95z5+vSo99h9oCW59WsnddrtCjGqtU= Received: by 10.49.40.11 with SMTP id s11mr562317nfj; Fri, 24 Mar 2006 18:16:55 -0800 (PST) Received: by 10.48.207.5 with HTTP; Fri, 24 Mar 2006 18:16:55 -0800 (PST) Message-ID: <6bde122b0603241816h3eb94db9v56db32446b5f6a6f@mail.gmail.com> Date: Fri, 24 Mar 2006 21:16:55 -0500 From: "Sandy McArthur" Sender: sandymac@gmail.com To: "Jakarta Commons Users List" Subject: Re: Connection not getting released to pool .. ORA-01453 error In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Can you provide any stack traces? On 3/24/06, vivek sar wrote: > Using, > torque-3.1.jar, commons-dbcp-1.2.1.jar, commons-collections-3.= 1.jar > > I am having this weird problem. In case an "insert" query fails > (could be for any reason) in my case it is because of bad blocks on > db, the subsequent query (like a "select" statement) gives me, > "ORA- 01453 - Set Transaction must be the first statement" > > error message. Once I get this exception the connection associated > with this error gets frozen - it never gets released to the connection > pool. I've configured maxActive to be 20 connections, so after 20 of > these "ORA-01453" messages my application freezes and all other tasks > just keep waiting for the connection indefinitely. > > I am using "SharedPoolDataSource" dbcp connection pool. > > I am not using Transaction explicitly in my code. To get connection I us= e, > > Torque.getConnection("xxxx"); > > I am not sure if this is a bug in torque or dbcp. On my code I don't > see any problem as I've the finally block where I close the connection > before exiting the method. > > Does anyone has any experience with this ? -- Sandy McArthur "He who dares not offend cannot be honest." - Thomas Paine --------------------------------------------------------------------- To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: commons-user-help@jakarta.apache.org