Re: Rollback statements in stored procedure

From: Joe Weinstein (joeNOSPAM_at_bea.com)
Date: 11/03/04

  • Next message: Jeges Endre: "Re: when and what to close java.sql.PreparedStatement" 
    Date: Wed, 03 Nov 2004 11:31:09 -0800
To: Kevin Arouza <kevarouza@hotmail.com>

    Did you make sure your JDBC connection was in autoCommit(false)
    mode before calling the procedure?
    Joe Weinstein at BEA

    Kevin Arouza wrote:

    > I am calling an Oracle stored procedure which returns the status
    > through an out parameter. If the status is 0 it means success, 1
    > indicates a failure. On failure, I want to rollback the changes made
    > in the stored procedure via a Connection.rollback(). Unfortunately,
    > this has no effect. Is there a way I can rollback the changes made by
    > a stored procedure?
    >
    > The reason I don't want to place the commit/rollback within the
    > procedure is because my client calls a set of 5 procedures
    > sequentially and if any one of them fail I have to rollback the
    > changes made by all the previous procedures. Any ideas?
    >
    > Thanks,
    > Kevin

  • Next message: Jeges Endre: "Re: when and what to close java.sql.PreparedStatement"

    Relevant Pages

    • Rollback statements in stored procedure
      ... I am calling an Oracle stored procedure which returns the status ... If the status is 0 it means success, ... On failure, I want to rollback the changes made ... Is there a way I can rollback the changes made by ...
      (comp.lang.java.databases)
    • JSTL - <sql:transaction>, rollback?
      ... reason for JSTL to decide to rollback a transaction. ... JSTL considers this a successful operation since no failure occurred ...
      (comp.lang.java.programmer)