RE: programmatic transaction management in ibatis

[Elangovan, Kumaravel]

Hi All,
 
Thanks for your help. We have implemented it using ibatis dao manager.
daoManager.startTransaction();
daoManager.commitTransaction();
daoManager.endTransaction(); 
 Its working fine.
 
Regards,
Kumar


  _____  

        From: Andrey Rogov [mailto:[EMAIL PROTECTED] 
        Sent: Tuesday, July 31, 2007 2:22 PM
        To: user-java@ibatis.apache.org
        Subject: Re: programmatic transaction management in ibatis
        
        
        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