Stored procedures will not help you with that. They are a mechanism to run code inside the database, on the database server. I would not advise to commit inside a stored procedure. It might surprise java developers who are trying to rollback. They think that they rolled back to were they started the transaction, but they are only rolling back to after the stored procedure (Applying the Rule of Least Surprise).
Regards, Jan [ May 12, 2007: Message edited by: Jan Cumps ]
OCUP UML fundamental
Joined: Jul 17, 2006
If you use only one Connection object you can do a rollback on all tables by: 1. conn.setAutoCommit(false); //default-value = "true" 2. conn.rollback() after failure, conn.commit() after succes.