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 jeffgbutler@gmail.com
 designates 209.85.162.182 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=QQvcYbPUjpw5ZrAg21uCxGu8lTifvnX8+UylIY+PMFIK5FcGlkzygZ+Yxnj4ptRje07wdZ2AUDNqoC0/VrTg9A4GKlpcwsXc+oqIs4wPPFsCkGt28QGk0Tq0AOb8+iDSUcj6x70zxwjmmA0YFuN5zSocWO6SLDgz6FDs8EyMyv4=
Message-ID: <c593b8750803041352v4841a1dfm922778b00ca20dd2@mail.gmail.com>
Date: Tue, 4 Mar 2008 15:52:47 -0600
From: "Jeff Butler" <jeffgbutler@gmail.com>
To: user-java@ibatis.apache.org
Subject: Re: queryForList/Map/Object... rollbacks
In-Reply-To: <B2C40C183B943C4EA9775DAE4CB0D6690103509F@EX2003.a-t-g.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_17926_6350215.1204667567503"
References: <B2C40C183B943C4EA9775DAE4CB0D6690103509F@EX2003.a-t-g.com>

------=_Part_17926_6350215.1204667567503
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

What transaction manager are you using?
Is this an EJB application with CMT, or just a web application?
Have you read the information in the WIKI about configuring iBATIS on
WebSphere?

http://opensource.atlassian.com/confluence/oss/display/IBATIS/Environment+Specific+Information

Jeff Butler


On Tue, Mar 4, 2008 at 3:32 PM, Tom Henricksen <TomH@a-t-g.com> wrote:

>  We are performance monitoring our application and my DBA let me know that
> we had over 3 MILLION rollbacks in a single day.  We are using WebSphere to
> DB2 on Win2k3 servers.
>
> I looked in our code and could not find anything.  Used p6spy and found
> that every time queryForXXX is called I received a rollback.  Stepping
> through the queryForList code in SqlMapExecutorDelegate.java the
> autoStartTransaction starts a transaction if none is present and since we
> don't have commitRequired set, the autoEndTransaction will cause a rollback.
>
> I assume there is a good reason to start the transaction here.  It seems
> like extra work creating a transaction that will always be rolled back.  Can
> someone explain why this is good to me so I can forward the information to
> my DBA?  Any links supporting the argument would be great.  Is there a way
> to use the queryForXXX without creating a transaction?  I assume it is
> better to not have commitRequired?
>
> Thanks for your time.
>
>
>
> *Tom Henricksen*
> Consultant
> Advanced Technologies Group, Inc.
>
>
>

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

<div>What transaction manager are you using?</div>
<div>Is this an EJB application with CMT, or just a web application?</div>
<div>Have you read the information in the WIKI about configuring iBATIS on WebSphere?</div>
<div>&nbsp;</div>
<div><a href="http://opensource.atlassian.com/confluence/oss/display/IBATIS/Environment+Specific+Information">http://opensource.atlassian.com/confluence/oss/display/IBATIS/Environment+Specific+Information</a></div>
<div>&nbsp;</div>
<div>Jeff Butler</div>
<div><br><br>&nbsp;</div>
<div class="gmail_quote">On Tue, Mar 4, 2008 at 3:32 PM, Tom Henricksen &lt;<a href="mailto:TomH@a-t-g.com">TomH@a-t-g.com</a>&gt; wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div lang="EN-US" vlink="purple" link="blue">
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">We are performance monitoring our application and my DBA let me know that we had over 3 MILLION rollbacks in a single day.&nbsp; We are using WebSphere to DB2 on Win2k3 servers.<br>
<br>I looked in our code and could not find anything.&nbsp; Used p6spy and found that every time queryForXXX is called I received a rollback.&nbsp; Stepping through the queryForList code in SqlMapExecutorDelegate.java the autoStartTransaction starts a transaction if none is present and since we don&#39;t have commitRequired set, the autoEndTransaction will cause a rollback.<br>
<br>I assume there is a good reason to start the transaction here.&nbsp; It seems like extra work creating a transaction that will always be rolled back.&nbsp; Can someone explain why this is good to me so I can forward the information to my DBA?&nbsp; Any links supporting the argument would be great.&nbsp; Is there a way to use the queryForXXX without creating a transaction?&nbsp; I assume it is better to not have commitRequired?<br>
<br>Thanks for your time.</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&nbsp;</span></font></p>
<p><strong><b><font face="Tahoma" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Tahoma">Tom Henricksen</span></font></b></strong><font face="Tahoma" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Tahoma"><br>
</span></font><font face="Tahoma" color="gray" size="2"><span style="FONT-SIZE: 10pt; COLOR: gray; FONT-FAMILY: Tahoma">Consultant<br>Advanced Technologies Group, Inc.</span></font></p>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">&nbsp;</span></font></p></div></div></blockquote></div><br>

------=_Part_17926_6350215.1204667567503--