This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
My question is about the exception and error handling in web application. If I use oracle procedures and functions for all business logic, then all the requests regarding select, update, delete and insertion of records using servlets, there might be a chance of run time errors and exceptions from oracle procedures. What is the best way to handle these exceptions and errors? and on which layer i handled these exceptions regarding transactions etc?