RE: Spring with IBatis and Transaction Manager Helps.

[Brian Parkinson]

Hi Bala:
 
I am using Spring with iBatis with transations. Below is the config that
I am using - note the use of the spring tx:* AOP transaction injection.
There are docs in the spring project related to how to set this up (mine
below is pretty much a copy of that example).
 
Hope it helps.
 
Brian Parkinson.
 
--- x8 snip
 
SqlMapConfig contains:
 
 <transactionManager type="EXTERNAL">
  <dataSource type="DBCP">
  </dataSource>
 </transactionManager>
 
Spring transactions:
 
 <bean id="txManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager"
>
  <property name="dataSource" ref="dataSource"/>
 </bean>
 
 <tx:advice id="txAdvice" transaction-manager="txManager">
  <tx:attributes>
   <tx:method name="get*" read-only="true" />
   <tx:method name="*" />
  </tx:attributes>
 </tx:advice>
 
 <aop:config>
  <aop:pointcut id="daoServiceOperation" expression="execution(*
com.ecobee.foundation.dao.ibatis.*.*(..))" />
  <aop:advisor advice-ref="txAdvice" pointcut-ref="daoServiceOperation"
/>
 </aop:config>
 
Spring datasource:
 
 <bean id="mapConfig"
class="org.springframework.core.io.ClassPathResource">
  <constructor-arg>
   <value>com/ecobee/foundation/dao/ibatis/SqlMapConfig.xml</value>
  </constructor-arg>
 </bean>
 
 <bean id="dataSource"
class="org.springframework.jdbc.datasource.TransactionAwareDataSourcePro
xy">
  <property name="targetDataSource">
   <ref local="dataSourceImpl"/>
  </property>
 </bean>
 
 <bean id="dataSourceImpl"
class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  <property name="driverClassName" value="com.mysql.jdbc.Driver" />
  <property name="url" value="jdbc:mysql:///ecobee" />
  <property name="username" value="XXX" />
  <property name="password" value="YYY" /> 
  <property name="initialSize" value="10" />
  <property name="maxActive" value="100" /> 
  <property name="maxIdle" value="16" />
  <property name="maxWait" value="2000" />
 </bean>
 
 <bean id="sqlMapClient"
class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
  <property name="dataSource" ref="dataSource" />
  <property name="configLocation" ref="mapConfig" />
 </bean>
 
 
 

________________________________

From: bala r [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 21, 2008 4:10 PM
To: user-java@ibatis.apache.org
Subject: Spring with IBatis and Transaction Manager Helps.


Hi,

I have to implement TransacationManager in my module using Spring with
Ibatis.

Here is my requirments.

TransacationProcessor  - 
  --Open Transacation
  --Call LoopProcessor(process multiple files )
           --- Call DatabaseProcessor
                      -- Call SQLMqpClient Insert/update/delete.
           -- Call OtherProcessor do Work.
  --All Success then Committransaction.
  -- If fails rollbackTransacation.
  --End Transaction.

Any documents for handling Spring and Ibaris or any examples i can get
from any source? 
I tried google Spring with Ibatis transaction but couldnt find any much
information.

Thanks
bala.