|Subject||Re: [firebird-support] Long running transactions|
>>>> - Is there always at least one active transaction per connected user;-)
>>>> or users can be connected without any active transactions?
>>> I will leave that to others. I think it depends a bit on the toolset you
>> Yes, it's dependent on the toolset, but I think the most used ones all
>> allow an active connection without an active transaction.
> Thanks, I wanted to make sure Firebird allowed this so that I can
> freely blame me and my toolset if there is any long running
> transactions. :)
A number one reason for a stuck OAT can be transaction which has been
*committed* with COMMIT RETAINING. Funny, right? Committed but still
Data access components tend to use commit retaining aka soft commits,
especially when being in autocommit mode.
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and