Lock conflict error with IBO

Article View: borland.public.interbase.sql

Article #11364

Back to borland.public.interbase.sql Previous Next

#11364

From: Gianluca Acciarri
Date: Mon, 25 Nov 2002 10:14

27 lines
1739 bytes


Hi
I have a connection to an IB 6.02 with IBO objects, i can't manage the
committ and rollback manually so my IB_Transaction
is configured with AutoCommit and Committed (ReadCommitted) i have a lot of
error (LockConflict in No Wait Transaction)
in a long updtae procedure that doesn't start from the user but automatic.
I tried to avoid this problem with a procedure like this

  i:=0;
  timeout:=20;
  ok:=false;
  while (ok=false) and (i<timeout) do begin
    try
      dsqlpro.ExecSQL;
      ok:=true;
    except
      inc(i);
      ok:=false;
    end;
  end;

What do you think about it ? Is this a right way to solve my problem or you
can suggest me a better way ?

Thank you in advance

Technical Details

Message-ID: <3de1f27b@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!news-FFM2.ecrc.net!news-raspail.gip.net!news.gsl.net!gip.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,8f02ad7601ab37df,start
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-11-25 02:09:22 PST
From: "Gianluca Acciarri" <acciarri_gianluca@hotmail.com>
Newsgroups: borland.public.interbase.sql
Subject: Lock conflict error with IBO
Date: Mon, 25 Nov 2002 11:14:44 +0100
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 81.72.27.119
Message-ID: <3de1f27b@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1038217851 81.72.27.119 (25 Nov 2002 01:50:51 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!news-FFM2.ecrc.net!news-raspail.gip.net!news.gsl.net!gip.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail