Subject Re: [firebird-support] Understanding Sweep
Author Aage Johansen
Erick Sasse wrote:
>
> I'm using Delphi with dbExpress and ClientDatasets in a 3-tier app.
> My transaction configuration is:
>
> CommitRetain=False
> Interbase TransIsolation=ReadCommited
>
> dbExpress should handle transactions automatically and I never
worried about it.
>
> What do you mean by "some abandoned ClientDataset"? My app is 3-tier,
> so the ClientDataset is completely disconnected. My app server is
> stateless. The db connection is not owned by any client.


Are you using some tool to (constantly) check activity? Perhaps a
tool that keeps a transaction open all the time?

--
Aage J.