Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of clinton.begin@gmail.com
 designates 209.85.146.180 as permitted sender)
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:content-transfer-encoding;
        b=bWqKLWWzckq638iGpqGEvsZZdAPjJEKJJvhXnqtooSYfJ9Gxrks5muHe3OMD9Azkxc
         /krfltEw1DG/NaUmPkWHAH+UhSt9UsTTUdhzJkur18NkHXwXyFMutnrwLwdBDSGqEFUJ
         tg6+/e53l0rlnEcqOLQcP7eXza+jAnUMN354I=
MIME-Version: 1.0
In-Reply-To: <497a5e2a.0589300a.0e2f.40c7@mx.google.com>
References: <497a5e2a.0589300a.0e2f.40c7@mx.google.com>
Date: Fri, 23 Jan 2009 21:11:52 -0700
Message-ID: <16178eb10901232011s28afe337ga90ff00b9dfa127c@mail.gmail.com>
Subject: Re: Transactions and Pooling
From: Clinton Begin <clinton.begin@gmail.com>
To: user-java@ibatis.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

The reason is so that you can implement the recommended coding pattern:

try {
  // start transaction
  // commit transaction
} finally {
  // end transaction
}

If you called commit OR end/rollback, you'd have to use a catch
block.... which sux. :-)

Cheers,
Clinton

On Fri, Jan 23, 2009 at 5:17 PM, Jonathan Moores
<jonathan.moores@gmail.com> wrote:
> Hi,
>
> I was wondering why there is a need to explicitly call
> SqlMapClient.endTransaction() in order to return a connection to the pool
> even after a commitTransaction()?
>
>
>
> I am using Tomcat 6.018 with Ibatis 2.34.726 and I see that the connections
> used in a transaction are never returned without the endTransaction() call
> which I actually equated to a rollback.
>
>
>
> Thanks
>
> Jon