If you are using jms you would get 2pc unless you modified the jaybird
-ds.xml to specify local transaction. Since jboss's tm doesn't do
recovery if something broke during commit you could easily get a limbo
tx.

Might not apply to you, but that's one easy way to get limbo tx.

david jencks

On Sep 14, 2004, at 1:06 PM, S. Radojcin wrote:

>
>
> 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(JDBCAbs
> tractQueryCommand.java:148)
>   at
>
> org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntityCommand.execute(JDBCFindEn
> tityCommand.java:44)
>            .......................
>
>
> -So, why deadlock, and why limbo transaction, can anyone tell me ?
>
>
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
> <81804_0704_b_300250a.gif>
> <l.gif>
>
> Yahoo! Groups Links
>
> • To visit your group on the web, go to:
> http://groups.yahoo.com/group/Firebird-Java/
>  
> • To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>  
> • Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>