Hi, we have a problem with applications of third party suppliers. We provide a database for data exchange between our system and a third party system. It often occurs, that the third party suppliers leave transactions open without committing them. This leads of course to a transaction diff and a slow system...
Actually we close the connection manually if we encounter such a problem, but an automatic solution would be better. Is there a possibility to set some kind of timeout on transaction or attachments, and once timeout is reached an automatic rollback is done? I know it's not a nice solution, but just to keep our system performing fast, we need to fix these problems automatically. Thanks for replies BR Harald
