My web application is divided into multiple modules spread across different JSP pages. Currently, I am facing the challenge of using separate oracle connection objects on each page due to scope limitations. The problem arises when I need to rollback database transactions from any of the JSP pages on a central display page with the click of a button. However, database rollback requires a connected connection object.
I am considering a solution where I maintain only one connection object, add it to the list of session variables, and then dereference it as needed. This approach would allow me to rollback database transactions from any page directly from the central display page. I am hopeful that this solution is feasible.