This week's book giveaway is in the Agile and Other Processes forum. We're giving away four copies of The Journey To Enterprise Agility and have Daryl Kulak & Hong Li on-line! See this thread for details.
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.