Return-Path: 
 <user-java-return-10369-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 96419 invoked from network); 23 Jan 2007 10:12:25 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 23 Jan 2007 10:12:25 -0000
Received: (qmail 39842 invoked by uid 500); 23 Jan 2007 10:12:29 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 39741 invoked by uid 500); 23 Jan 2007 10:12:28 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 39730 invoked by uid 99); 23 Jan 2007 10:12:28 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 23 Jan 2007 02:12:28 -0800
X-ASF-Spam-Status: No, hits=3.9 required=10.0
	tests=FROM_ALL_NUMS,HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: domain of 226057@gmail.com designates
 64.233.182.184 as permitted sender)
Received: from [64.233.182.184] (HELO nf-out-0910.google.com) (64.233.182.184)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 23 Jan 2007 02:12:19 -0800
Received: by nf-out-0910.google.com with SMTP id l24so169296nfc
        for <user-java@ibatis.apache.org>;
 Tue, 23 Jan 2007 02:11:58 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=Rk21iJtqshZT3Nq7tg2EPL59Pycn1Sf3+++DpV32njA1c72Nh3/lLE9FdIrq0jMQ3aqQkHHieuubkav1VH1qJR4J7KXgfTM0L9FN6upPlh+L/Q8qbV56kRT9tyEtl+I9CIeYdWXKjDVH2rGTjzUnkXAVx/y7uzvTJZwLUV5whaw=
Received: by 10.49.41.18 with SMTP id t18mr723170nfj.1169547118057;
        Tue, 23 Jan 2007 02:11:58 -0800 (PST)
Received: by 10.66.238.2 with HTTP; Tue, 23 Jan 2007 02:11:57 -0800 (PST)
Message-ID: <46d2280d0701230211w5d80b8dob7cbb135dff60659@mail.gmail.com>
Date: Tue, 23 Jan 2007 14:11:57 +0400
From: "Koka Kiknadze" <226057@gmail.com>
To: user-java@ibatis.apache.org
Subject: Re: Autocommit not properly handled in Ibatis.
In-Reply-To: <16178eb10701220909x2c3c7fd0jcdb99b825e0dd7e1@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_156098_19406940.1169547117936"
References: <D2909F64E8DF6A4DA12D5D83BFF5D6070588014B@ddsmttayz026>
	 <003601c73e45$5eac8aa0$0d10a8c0@coan>
	 <16178eb10701220909x2c3c7fd0jcdb99b825e0dd7e1@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org

------=_Part_156098_19406940.1169547117936
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

>
>
>
> iBATIS always commits or rolls back transactions explicitly with
> commit() and rollback().
>
> Clinton
>

IJust to spare someone's time  I'd like to add that it is only true if
1. Threre were some insert/update/delete or procedure calls after
startTransaction()
OR
2. The forceCommit (commitRequired) property is set to true

I.e. if, after startTransaction(), only select statements are executed and
forceCommit is set to false, no commit is issued to the database even if you
call commit in iBatis.
I've lost couple of hours until Jeff explained that to me and I hope I got
it right.

------=_Part_156098_19406940.1169547117936
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br><br>iBATIS always commits or rolls back transactions explicitly with<br>commit() and rollback().
<br><br>Clinton<br></blockquote></div><br>IJust to spare someone&#39;s time&nbsp; I&#39;d like to add that it is only true if<br>1. Threre were some insert/update/delete or procedure calls after startTransaction()<br>OR<br>2. The forceCommit (commitRequired) property is set to true
<br><br>I.e. if, after startTransaction(), only select statements are executed and forceCommit is set to false, no commit is issued to the database even if you call commit in iBatis.<br>I&#39;ve lost couple of hours until Jeff explained that to me and I hope I got it right.
<br>

------=_Part_156098_19406940.1169547117936--