goody! I love you compare your own statements with this huge bible that you wrote for me to refer which I know by heart. And yes I do know who Rod johnson is and his relation to spring framework. I also know his relation to interface21. Therefore quote his writings and don't scold me with his name. I would suggest you reread the last para of what you wrote. I never said stored procedures are not good all together. Stored procedures are useful and extremely useful when it comes to complex calculations on values stored in database rather than making 15 different database calls from java code to complete the task. Dang Rod! is it your writing that is making hard for people to understand or is it them?
Lets get back to scenario, so you want to go through pains of doing a database IO just to know if provided data is dirty data?
Hummmm, I wonder if Rod Johnson ever mentioned in his book that "Round trips are not good for just to know if provided data would violate RI of database.