Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 56170 invoked from network); 11 Feb 2011 11:55:21 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 11 Feb 2011 11:55:21 -0000 Received: (qmail 27525 invoked by uid 500); 11 Feb 2011 11:55:21 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 27072 invoked by uid 500); 11 Feb 2011 11:55:18 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 27064 invoked by uid 99); 11 Feb 2011 11:55:17 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 11 Feb 2011 11:55:17 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of p.stivel@gmail.com designates 209.85.210.172 as permitted sender) Received: from [209.85.210.172] (HELO mail-iy0-f172.google.com) (209.85.210.172) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 11 Feb 2011 11:55:12 +0000 Received: by iym1 with SMTP id 1so2510802iym.31 for ; Fri, 11 Feb 2011 03:54:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=a7fgnYsnfEQ76isQQ8bhLVmLYn2EVmxnHdSctgdT0A4=; b=DcbFeky0A15AgCXwvxPlpLrWdZGFla0tiihJylHxYtRDGyj03d6iM2kAho9oU/2uIW j0ED84aJBkTkxm9iPmzO8IxI6LfYkttVBlrzRaV08Yysx19P9qJhrXii5TdlFrvQr+fU nCsjneIfydPw+I6WNZt91OrhCBOutK4wKHZWc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=BZNQptUplmTOY7s+9oDJ4PKQcKK8ATYdtE69BqCVrys4QeGHrP4tLfWhQaxhCDRgz1 MT0P9QO5aNNcF9tbcZ/BKQsV9tVIARvtPXFs1dozD/8G581iXBX7cjuIzq1uYToisXA1 mrAAn9vlEyq/I5XF10I75c71AZol9kmCdRu2k= MIME-Version: 1.0 Received: by 10.231.10.197 with SMTP id q5mr275501ibq.197.1297425291431; Fri, 11 Feb 2011 03:54:51 -0800 (PST) Received: by 10.231.155.139 with HTTP; Fri, 11 Feb 2011 03:54:51 -0800 (PST) In-Reply-To: <4D551BE3.7040806@nomagic.com> References: <4D550918.7080106@nomagic.com> <4D551BE3.7040806@nomagic.com> Date: Fri, 11 Feb 2011 17:24:51 +0530 Message-ID: Subject: Re: Closing connection result with exception From: "Sakthivel.P" To: Derby Discussion Content-Type: multipart/alternative; boundary=00032557a38a9e517c049c005dae --00032557a38a9e517c049c005dae Content-Type: text/plain; charset=ISO-8859-1 refer this http://db.apache.org/derby/docs/10.4/devguide/cdevconcepts29416.html default auto commit is set true. if its turned off, need to commit explicitly. http://db.apache.org/derby/manuals/tools/tools46.html regards Sakthivel On Fri, Feb 11, 2011 at 4:52 PM, Egidijus Vaisnora < egidijus.vaisnora@nomagic.com> wrote: > > I have updated derby but still the same. Issue DERBY-3806 covers problem > when ResultSet was not closed, however I am closing ResultSet, prepared > statement and then connections. What I am not doing is commit either > rollback calls - jsut because I am executing SELECT statement. Do I need to > call "commit" or "rollback" in any case before "close", even if I am using > SELECT statement and I am closing opened ResultSet and prepared statement? > > -- > Egidijus > > On 2/11/11 12:10 PM, Sakthivel.P wrote: > >> 10.7.1.1 is >> latest version. Please download and use. >> >> >> http://db.apache.org/derby/derby_downloads.html >> >> refer this issue for more details >> https://issues.apache.org/jira/browse/DERBY-3806 >> >> - Sakthivel >> >> On Fri, Feb 11, 2011 at 3:32 PM, Egidijus Vaisnora < >> egidijus.vaisnora@nomagic.com > >> wrote: >> >> Hello All, >> >> I am using Embedded Derby and whenever I attempt to close >> connection I got "Cannot close a connection while a >> transaction is still active." error. >> I am using Derby 10.5.3. I found that in Derby 10.5.1.1 in >> release notes there is a note about DERBY-3319, which >> states that "Users must call commit() or rollback(), or use >> auto-commit, before attempting to close a connection with >> uncommitted operations." But I am executing just "select" statement, do >> I still need to call rollback or commit? >> >> P;ease, advice, >> -- >> Egidijus >> >> >> --00032557a38a9e517c049c005dae Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable refer thishttp://db.apache.org/derby/docs/10.4/devguide/cde= vconcepts29416.html

default auto commit is set true. if its turned off, need to commit expl= icitly.

http://db.apache.org/derby/manuals/tools/tools46.html

regards
Sakthivel

On Fri= , Feb 11, 2011 at 4:52 PM, Egidijus Vaisnora <egidijus.vaisno= ra@nomagic.com> wrote:

I have updated derby but still the same. Issue DERBY-3806 covers problem wh= en ResultSet was not closed, however I am closing ResultSet, prepared state= ment and then connections. What I am not doing is commit either rollback ca= lls - jsut because I am executing SELECT statement. Do I need to call "= ;commit" or "rollback" in any case before "close",= even if I am using SELECT statement and I am closing opened ResultSet and = prepared statement?

--
Egidijus

On 2/11/11 12:10 PM, Sakthivel.P wrote:
10.7.1.1 <http://db.apache.org/derby/releases/release-10.7.1= .1.cgi> is latest version. Please download and use.
On Fri, Feb 11, 2011 at 3:32 PM, Egidijus Vaisnora <egidijus.vaisnora@nomagic.co= m <mailto:egidijus.vaisnora@nomagic.com>> wrote:

=A0 =A0Hello All,

=A0 =A0 =A0 =A0 =A0 =A0I am using Embedded Derby and whenever I attempt to= close connection I got "Cannot close a connection while a
=A0 =A0transaction is still active." error.
=A0 =A0 =A0 =A0 =A0 =A0I am using Derby 10.5.3. I found that in Derby 10.5= .1.1 in release notes there is a note about DERBY-3319, which
=A0 =A0states that "Users must call commit() or rollback(), or use au= to-commit, before attempting to close a connection with
=A0 =A0uncommitted operations." But I am executing just "select&= quot; statement, do I still need to call rollback or commit?

=A0 =A0P;ease, advice,
=A0 =A0--
=A0 =A0Egidijus



--00032557a38a9e517c049c005dae--