ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "bala r" <bala...@gmail.com>
Subject Re: Spring with IBatis and Transaction Manager Helps.
Date Fri, 22 Aug 2008 15:04:23 GMT
Hi Brian,

Thank you so much.. I will try your config.. I want to handle the
transaction in the Service layer not in DAO.
I will implement the same config and call the AOP in the service layer.

Thanks
Bala.

On Fri, Aug 22, 2008 at 7:36 AM, Brian Parkinson <parki@avaning.com> wrote:

>  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.TransactionAwareDataSourceProxy">
>   <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:balar4u@gmail.com]
> *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.
>

Mime
View raw message