Re: programmatic transaction management in ibatis

[Andrey Rogov]

Kumar, may be this should help.
programmatic transaction management method -

import org.springframework.transaction.PlatformTransactionManager ;
 import org.springframework.transaction.TransactionDefinition ;
 import org.springframework.transaction.TransactionStatus ;
 import org.springframework.transaction.DefaultTransactionDefinition ;


private PlatformTransactionDefinition transactionManager ;

private TransactionDefinition getDefinition( int isolationLevel) {
      DefaultTransactionDefinition def = new  DefaultTransactionDefinition(
TransactionDefinition.PROPAGATION_REQUIRED) ;
      def.setIsolationLevel(isolationLevel) ;
      return def ;
}

public void insert( Parameterobject object ) {
      TransactionStatus status = transactionManager.getTransaction(
getDefinition(TransactionDefinition.ISOLATION_READ_COMMITED)) ;
       try {
                insert( object  ) ;
                transactionManager.commit(status) ;
       }
        catch ( Throwable t ){
                transactionManager.rollback(status) ;
       }
  }






2007/7/30, Elangovan, Kumaravel <[EMAIL PROTECTED]>:
>
>
> Hi,
>
> We would like to implement programmatic transaction management in one
> action class of our application (spring with ibatis SQL maps) as it involves
> in updation of two tables.
>
> current* SqlMapConfig.properties* is
>
>         <transactionManager commitRequired="true" type="JDBC">
>                 <dataSource type="JNDI">
>                         <property name="DataSource"
> value="${datasourcename}"/>
>                 </dataSource>
>         </transactionManager>
>
> and* dao.xml* is
>
> <daoConfig>
>         <!-- Example SQL Maps DAO Configuration -->
>         <context>
>                 <transactionManager type="SQLMAP">
>                         <property name="SqlMapConfigResource"
> value="ibatis/FsaPlusAdmin/SqlMapConfig.xml" />
>                 </transactionManager>
>                 <dao interface="name of the interface"
> implementation="name of the implementation" />
> </context>
> </daoConfig>
>
> We want transaction to be remanin default except in that action class(Here
> transaction has to be rolled back if updation of 1st table fails).
>
> As I am new to ibatis, could anyone please explain how to configure
> external transaction and to use that in the action class.
>
> Regards,
> kumar
>