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
>
