Subject Re: [firebird-support] Re: Next TX #, OAT and Connection Duration?
Author Dan Wilson
>We do not explicitly issue commits. The BDE manages this through its
>"Shared Autocommit" support. We have examined the code and do not
>find active transactions being held open for an excessive or
>unexpected length of time. Here are our connection settings:

Unless I am very much mistaken, BDE shared autocommits function using commit-retaining, which would cause precisely the problems you are seeing. Getting periodic hard commits into your transactions will resolve this.

Best regards,

Dan.