I work with Oracle (jbdc) in web developpment.
Presently with java, when we close the Oracle Connection, a commit is made automatically.
I want to change it to an automatic rollback when I close the connection (myConn.lose() ).
The reason is when a user submits a form (in the browser) and he clicks the stop button before the process is terminated, the connection is closed automatically and a commit is done. I don't want a commit because my source code is doing several inserts in several tables and if the process is interrupted before all is done, I want a rollback otherwise the data will be corrupted.
Can I do it and Who ? Maybe overload the close() method ? How ?
Thank You,
mhuot