db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "zak allen" <zak...@gmail.com>
Subject ERROR 40XC0: Dead statement
Date Mon, 19 Nov 2007 07:46:28 GMT
After catching that I've become a deadlock victim in a transaction
(within a stored procedure) using:

} catch (SQLException se) {
    	if ((!se.getSQLState().equals("40001"))...

.. I retry my transaction (without returning from the stored procedure).

The retry completes without problems but 'ij' shows the messsage:

"ERROR 40XC0: Dead statement. This may be caused by catching a
transaction severity error inside this statement."

and does not display the resultset from the procedure.

Is there anyway to avoid this?

(If the retry succeeds I'd like the deadlock to be invisible to the caller.)

View raw message