Lock conflict error with IBO

Thread View: borland.public.interbase.sql

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Gianluca Acciarri Mon, 25 Nov 2002 10:14

#11364

Author: 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

Re: Lock conflict error with IBO

#11373

Author: Craig Stuntz TeamB
Date: Mon, 25 Nov 2002 15:57

16 lines
1483 bytes

In article <3de1f27b@newsgroups.borland.com>, 
acciarri_gianluca@hotmail.com says...
> 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
> 
	Multi-posted and off-topic in this newsgroup.

	Please do not multi-post.

	-Craig

-- 
Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor
InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads