> my colleague develops an application with a connect to firebird 2.5 with
> zeos and Delphi. Now, after each call of a procedure he reconnect the
> connection. Gstat shows me, that the oldest transaction remains and only the
> next transaction counter continuous. Even the application is closed, the
> oldest transaction remains.
>
>
>
> He has activated the autocommit-mode.
>
>
>
> Does anyone have an idea what's going on?

Zeos = Evil in respect to transaction handling. Haven't checked lately,
so it might got better over time, but last time I checked, Zeos only
supported commit/rollback retaining. Hard commits are only available at
disconnect. AFAIR.

I would check what's going on under the hood. Perhaps Zeos does have
some kind of specialized SQL monitor or as you are using Firebird 2.5,
you could grep a trial copy of FB TraceManager Enterprise Edition and
see what's going on. ;-)

http://www.upscene.com/downloads.php#fbtm



--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!