Subject Re: [Firebird-Java] What means this exception ?
Author S. Radojcin
Paul Beach wrote:

>>org.firebirdsql.jdbc.FBSQLException: GDS exception. deadlock record from
>>transaction 19474 is stuck in limbo
>>
>>
>
>It means exactly what it says, I suspect. You have a limbo transaction, thats
>generating a deadlock error.
>

- but, I don't have a transaction that spans multiple databases at all;
nor two-phase commit; nor subtransactions;
for conclusion - there is no conditions for limbo transaction, I think.

Still, this exception happens when I try to obtain local interface of my
entity EJB, by calling one of finder methods.
Then, FinderExceptions throws, with this message:
----------------
javax.ejb.FinderException: Find failed:
org.firebirdsql.jdbc.FBSQLException: GDS Exception. deadlock
record from transaction 19474 is stuck in limbo
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:148)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntityCommand.execute(JDBCFindEntityCommand.java:44)
.......................


-So, why deadlock, and why limbo transaction, can anyone tell me ?