Re: Transactin and Rollback.
You are not showing us all the code. From what we see .. Insert and Post
work , so no exception is being raised so the "commit" is working at the end
of the very first successful detail insert and the transaction is being
ended as successful.
What exception is taking place that is not causing the rollback to be done
??
and ... your insert of the master will never be rolled back if the commit of
the details ever takes place.
.
Relevant Pages
- Re: HELP ME
... We need to insert/update data from temp table to staging tables. ... any User Define Exception to be handled and then use Raise Exception ... Above code template does not specify Commit statement. ...
(comp.databases.oracle.misc) - HELP ME
... We need to insert/update data from temp table to staging tables. ... any User Define Exception to be handled and then use Raise Exception ... Above code template does not specify Commit statement. ...
(comp.databases.oracle.misc) - Re: HELP ME
... We need to insert/update data from temp table to staging tables. ... any User Define Exception to be handled and then use Raise Exception ... Above code template does not specify Commit statement. ...
(comp.databases.oracle.misc) - Re: HELP ME
... We need to execute update first and if SQL%ROWCOUNT < 1 then need to ... any User Define Exception to be handled and then use Raise Exception ... Above code template does not specify Commit statement. ... Name, Table primary key etc. ...
(comp.databases.oracle.misc) - Re: Behavior of Connection.commit()
... >>> If the exception from the 1st insert was a statement level exception ... If the caller wants to continue, ... >>> commit(), then they should be allowed to do so. ... >>> connection, so the caller should be able to call commitimmediately. ...
(microsoft.public.sqlserver.jdbcdriver) |
|
