Return-Path: 
 <user-java-return-11911-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 90211 invoked from network); 25 Jun 2007 15:08:56 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 25 Jun 2007 15:08:56 -0000
Received: (qmail 31551 invoked by uid 500); 25 Jun 2007 15:08:56 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 31535 invoked by uid 500); 25 Jun 2007 15:08:56 -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 31524 invoked by uid 99); 25 Jun 2007 15:08:55 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 25 Jun 2007 08:08:55 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: local policy)
Received: from [68.142.200.144] (HELO web30801.mail.mud.yahoo.com)
 (68.142.200.144)
    by apache.org (qpsmtpd/0.29) with SMTP; Mon, 25 Jun 2007 08:08:51 -0700
Received: (qmail 66282 invoked by uid 60001); 25 Jun 2007 15:08:30 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
  b=3BBhzFjkHifntUVL/WsUcdYwXZb0CKOt7a0iYZUUSYCa5llX+dRQXvPmtXRKiRUu6WHM1DQLwPYDd1hclH4D7Y+vqky/3iMPnWMvnhMw8dLLdaL7tBsYhz1CtvV1f+adGg/Aw28gGwreqylLs0w4VhEbQ4ybmGSmVrYRvWGjxTI=;
X-YMail-OSG: 
 fyI9Q4wVM1mbN7SMpfYnLg8IpPKPLPHDxBSdFyR96o1nGDFHtTnr3HtmoT2ziQtiYg--
Received: from [12.171.160.202] by web30801.mail.mud.yahoo.com via HTTP;
 Mon, 25 Jun 2007 08:08:29 PDT
Date: Mon, 25 Jun 2007 08:08:29 -0700 (PDT)
From: Robert Glover <robertgloverjr@yahoo.com>
Subject: Question on using Transactions with iBatis and Spring
To: user-java@ibatis.apache.org
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <999856.66272.qm@web30801.mail.mud.yahoo.com>
X-Virus-Checked: Checked by ClamAV on apache.org

I am confused over how to use transactions with iBatis and Spring. (I'm
actually using iBatis and Abator and Spring).

   The Spring 2.0.6 manual (section 12.5) says,

    "...Transaction management can be handled through Spring's standard
facilities.  There are no special transaction strategies for iBATIS, as there
is no special transactional resource involved other than a JDBC Connection.
Hence, Spring's standard JDBC DataSourceTransactionManager or
JtaTransactionManager are perfectly sufficient. ..."

    On the other hand, page 152 of the book "iBatis in Action" by
Begin/Goddin/Meadors says:  "...Local transaction are configured in the iBatis
SQL Map configuration XML file as a JDBC transaction manager."  The iBatis book
then shows an example of using "sqlMapClient.startTractsion()",
"sqlMapClient.commitTransaction", and "sqlMapClient.endTransaction()".

    In my sql-map-config.xml I don't have any transaction related statements at
all.  In my Spring application context file I have: 

<!-- SqlMap setup for iBATIS Database Layer -->
<bean id="sqlMapClient"    
class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
    <property name="configLocation" value="WEB-INF/sql-map-config.xml"/>
    <property name="dataSource" ref="dataSource"/>
</bean>

     Can anybody add any light on using iBatis with Spring and transactions?
Note that because I use Abator (a wonderful facility) I don't write an iBatis
code at all, I just invoke the methods on the DAOs that Abator creates.

Robert