On Sun, 28 Nov 2004 18:36:27 +1100, Helen Borrie <helebor@...>
wrote:

> At 05:59 PM 28/11/2004 +1100, you wrote:
>
>> > Hello,
>> >
>> > If the client application abnormally disconnected (crashed), what
>> > happened to the app's open transaction?
>>
>> this will result in a transaction in limbo - it has the same effect as a
>> rollback but it leaves more garbage for you to clean up.
>
> No, this isn't correct. Limbo transactions occur between the first and
> second commit or rollback phases of a multi-database transaction, if the
> connection to one or more databases is lost before the second commit or
> rollback phase completes.
>
> When clients crash, or applications don't take proper care of
> transactions
> when users log out, the server will eventually detect the lost connection

You say 'eventually'.
What if server does not detect lost of connection?

--
Miroslav Penchev