> What I want to know : is there necessary to do a st.executeUpdate("ABORT
> TRANSACTION") in the catch instruction block ?
> I recall that someone says that an error inside a transaction block
> automatically aborts the transaction.
> Is it true ? It works here ?
Someone else probably has up to date information. I recall that if an
error happens within a BEGIN/END block, all other commands are
rejected until an END (or ABORT?) is executed. The assumption is that
if something fails within a transaction you want to rollback
everything else within that transaction, and the transaction isn't
over until you explicitly complete it.
Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California
In response to
pgsql-interfaces by date
|Next:||From: Ari Halberstadt||Date: 1999-04-15 15:45:31|
|Subject: Re: [INTERFACES] JDBC (executing transactions coding style)|
|Previous:||From: Peter Mount||Date: 1999-04-15 13:49:01|
|Subject: RE: [INTERFACES] JDBC (executing transactions coding style)|