You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by zak allen <za...@gmail.com> on 2007/11/19 08:46:28 UTC

ERROR 40XC0: Dead statement

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.)