ibatis queries execution

[venkat penmatsa]

Hi All,

I have a requirement where i have to execute 3 ibatis queris in order, if any query execution failed all 3 queries should be roll back
please let me know how to implement this scenario in ibatis.




Thanks,
Venkat.

[amit punekar]

Hello,
I do not recollect if we can do this in iBatis. You may probably need to take care of calling these queries in a transactional scope ( for e.g. stateless session bean's method) and throw the EJBException when you encounter failed query. This would make sure your transaction is rolled back.

Regards,
Amit