Execute stored procedures

[ami]

Hello,

I have some Java code which creates 2 connections to the database. Each connection begin a transaction and executes a stored procedure.

Is there a way to monitor each transaction so that only if both executions of the stored procedures were successful then commit both transactions ?

If any of the stored procedure executions were unsuccessful (or there was any database error), then rollback both transactions.

Any ideas please ?

Many thanks.

[Hack]

Have a look here.

http://msdn.microsoft.com/en-us/library/ms187844.aspx