Execute stored procedures
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 ?
I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
Please use [Code]your code goes in here[/Code] tags when posting code.
Before posting your question, did you look here
Got a question on Linux? Visit our Linux sister site.
Modifications Required For VB6 Apps To Work On Vista
By New Developer in forum Database
Last Post: 03-27-2003, 11:46 AM
By Richard Hsu in forum VB Classic
Last Post: 12-05-2001, 05:26 AM
By CB Green in forum Database
Last Post: 06-25-2001, 11:35 AM
By Alp Guner in forum Database
Last Post: 03-01-2001, 11:49 PM
By Nicole Hagler in forum Database
Last Post: 09-06-2000, 10:03 AM
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center