ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Butler" <jeffgbut...@gmail.com>
Subject Re: queryForList/Map/Object... rollbacks
Date Tue, 04 Mar 2008 21:52:47 GMT
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.
>
>
>

Mime
View raw message