> > > I probalbly have a transaction that remained open.
> > > I'm having trubble finding it though.
> > > Do you have any ideas how to approach this problem ?
> > > I found all the places at the code that calls setAutoCommit and it
> > > looks fine. I also worked with a db after backup/restoring and it is
> > > not reproduced(next transaction= 1+snapshot transaction).
> > > So its a specific transaction that I need to trace.
> > > Any suggestions ?
> >
> >autocommit is often referred to as commit retaining.
>
> No. Autocommit works in different ways in different
> implementations. Delphi happens to use CommitRetaining when it does its
> "client-side autocommit".

Actually, not Delphi... But I guess you mean "IBX". I don't think IBO
does a CommitRetaining unless you tell it to. How about FIB+?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com