How can I rollback when connection close?

[marie-france huot]

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

[Praveen Kumar Jha]

Implement fa�ade pattern - wrap all the method of Connection inside other class - say OraConnection with java.sql.Connection as its data member. Your application will make call to OraConnection which will have a method close(). close() will first rollback on Connection and the close the connection.

[sim sim]

Hi,
Not sure about this, why dont u try JTA. Using transactions u can put a bunch of JDBC code in a block. It is either execute all or execute none situation. I mean to say if there are three statements, 2 are executed and 1 fails to execute, then the other 2 gets rolledback automatically.
Regards,
Sim Sim.

[Jamie Robertson]

Why can't you just explicitly call conn.rollback() at every possible close point?