Subject Re: how transaction behaves
Author Adam
--- In firebird-support@yahoogroups.com, "women_lover_best"
<talbronstien@g...> wrote:
> Hi,
>
> In my windows app in .net,i open a transaction..do some updates but
> before i say commit..power goes off on local machine but server is
> on..how will firebird treat this transaction?

Originally as an uncommitted transaction that is flagged as active. So
other transactions will not see the changes made by this transaction.
Eventually, Firebird will notice that the connection has not sent its
stay alive packet, and will rollback the transaction.

20 minutes comes to mind, but that might be something else.

The important thing though is that the uncommitted changes will be
rolled back, so you get to keep your atomicity.

Adam