This week's book giveaway is in the OCMJEA forum. We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara 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?