Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 11035 invoked from network); 11 Feb 2011 10:01:39 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 11 Feb 2011 10:01:39 -0000 Received: (qmail 10487 invoked by uid 500); 11 Feb 2011 10:01:39 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 10229 invoked by uid 500); 11 Feb 2011 10:01:36 -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 10205 invoked by uid 99); 11 Feb 2011 10:01:34 -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 10:01:34 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of egidijus.vaisnora@nomagic.com designates 91.220.20.1 as permitted sender) Received: from [91.220.20.1] (HELO gate.nomagic.com) (91.220.20.1) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 11 Feb 2011 10:01:25 +0000 X-Trusted-NM: yes Received: from suka.nomagic.com (suka.nomagic.com [91.220.20.178]) by gate.nomagic.com (Postfix) with ESMTP id 04C588961 for ; Fri, 11 Feb 2011 12:00:58 +0200 (EET) Message-ID: <4D550918.7080106@nomagic.com> Date: Fri, 11 Feb 2011 12:02:00 +0200 From: Egidijus Vaisnora User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2.13) Gecko/20101207 Thunderbird/3.1.7 MIME-Version: 1.0 To: derby-user@db.apache.org Subject: Closing connection result with exception Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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