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.
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop