Execute stored procedures


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Execute stored procedures

  1. #1
    Join Date
    May 2004
    Posts
    242

    Execute stored procedures

    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.

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663

Similar Threads

  1. Execute Permission on Stored Procedures
    By New Developer in forum Database
    Replies: 1
    Last Post: 03-27-2003, 11:46 AM
  2. DB Independent Application..What abt Stored Procedures
    By Richard Hsu in forum VB Classic
    Replies: 0
    Last Post: 12-05-2001, 05:26 AM
  3. Executing Stored Procedures
    By CB Green in forum Database
    Replies: 0
    Last Post: 06-25-2001, 11:35 AM
  4. Replies: 3
    Last Post: 03-01-2001, 11:49 PM
  5. Stored procedures and Active X Objects
    By Nicole Hagler in forum Database
    Replies: 0
    Last Post: 09-06-2000, 10:03 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center