| Subject | Re: [firebird-support] lock_timeout or isc_tpb_lock_timeout? |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2019-04-19T05:59:38Z |
On 16-4-2019 21:05, hamacker sirhamacker@... [firebird-support] wrote:
syntactically correct set transaction statement, you'd normally use
driver-specific ways of configuring and starting your transaction. And
then using LOCK TIMEOUT 300 would be 300 seconds which is 5 minutes.
[1]:
https://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-transacs-statements.html#fblangref25-transacs-settransac
--
Mark Rotteveel
> If I do:No, because that would be a syntax error (see [1]). Even if it were a
> SET TRANSACTION TO 300
> In ExecSQL, my currenty transaction will be waitting 30 sec?
syntactically correct set transaction statement, you'd normally use
driver-specific ways of configuring and starting your transaction. And
then using LOCK TIMEOUT 300 would be 300 seconds which is 5 minutes.
[1]:
https://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-transacs-statements.html#fblangref25-transacs-settransac
--
Mark Rotteveel