Interbase deadlock detected, DRIVER FLAGS, 512, soft commit, hard commit

Company

SQL LINKS DEVELOPER SUPPORT

SEARCH Borland Online/Developer Support

Tech Notes Index

Interbase deadlock detected, DRIVER FLAGS, 512, soft commit, hard commit The default Interbase isolation level was changed in in BDE/SQL Links 3.5 at the request of some of our customers and, as a result, internal Borland folks (*Please read the SQL Links 4.0 READLINK.TXT "BEHAVIOR CHANGES" section for a simple description of "hard" vs. "soft" commits*). The Interbase SQL Links driver can be set to use "soft commit" instead of "hard commit" by setting the Interbase DRIVER FLAGS to either 4096 or 4068 (please see the READLINK.TXT fro details.) The current (BDE 4.0) drawback to this (at least until the next version of the Interbase SQL Links driver comes out [v4.01]) is that NO WAIT is used with NO RECORD VERSION which can result in immediate deadlocks. By adding 512 to the DRIVER FLAGS param you are setting the driver default back to a REPEATABLE READ (RECORD VERSION) isolation level which helps to avoid a "deadlock detected error" condition. PUB IB LINK ERROR CJ, RG, PP 7.9.97