|Subject||Re: [firebird-support] Automatic Transaction/Attachment closure on client connection lost or timeou|
we have a problem with third part systems connection to our DB. Actually we provide a database for data exchange between our system and third party systems.
The problem is, that sometimes the third party systems leave transactions open. Of course this leads to a transaction diff, ending in a bad performing system.
The third party suppliers will not fix the problem, even if caused by them.
So the idea was, if the FB had a possibility to automatically close transaction after a configured timeout (Maybe configured per attachment) and to do a rollback in such cases.
It might be that data is lost in such a case, but the external systems have do deal with this issue....
Thanks in advance and BR