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 ]