Using Transaction with Lock and timeout

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Realtime
Posts: 6
Joined: Thu 19 Mar 2009 15:21

Using Transaction with Lock and timeout

Post by Realtime » Mon 22 Jun 2009 12:21

How can I use the new feature LOCK TIMEOUT from Firebird 2.1 with the TIBCTransaction component?

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Thu 25 Jun 2009 08:20

IBDAC does not support this feature.

Comed
Posts: 7
Joined: Mon 23 Mar 2015 13:19

Re: Using Transaction with Lock and timeout

Post by Comed » Fri 29 Apr 2016 14:13

Hi,
after some years is IBDAC going to support this feature someday?
with growing Databases and number of users this feature is standard for almost all databases.

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Using Transaction with Lock and timeout

Post by ViktorV » Wed 04 May 2016 14:24

To specify LOCK TIMEOUT for a transaction, you should set the lock_timeout transaction parameter. Here is an example:

Code: Select all

IBCTransaction.Params.Add('lock_timeout=10');

Post Reply