Henner Kollmann wrote:

> That's interesting. I firebird really killing the transaction or will it
> wait infinite until the client will kill the connection?

I've tested here with IBExpert and it looks like the connection is not
really killed, the deadlock error returns, but until I don't explicitly
rollback the transaction the other transaction maitain waiting.

** To test it I've used the parameter "isc_tpb_wait" in Data Transaction
Properties

> Is it possible to wait only a few seconds and catch an error then?
> Is it possible to log which table is deadlocked?

I don't know. :-)




_______________________________________________________
Yahoo! Messenger com voz: PROMOÇÃO VOCÊ PODE LEVAR UMA VIAGEM NA CONVERSA. Participe! www.yahoo.com.br/messenger/promocao