Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Restricted transaction
Mon, Oct 30 2006 12:25 PMPermanent Link

"Jose Eduardo Helminsky"
Tim

One session:

       TableList := TStringList.Create;
       try
           TableList.Add('table1');
           TableList.Add('table2');
           Database.StartTransaction(TableList);
       finally
           TableList;
       end;

Another session/part of the program

       TableList := TStringList.Create;
       try
           TableList.Add('table2');
           TableList.Add('table1');
           Database.StartTransaction(TableList);
       finally
           TableList;
       end;

Look the order of locking tables.
Could this generate a dead lock ? I reproduce here a little piece of code
representing an internal function in my application. Should I sort the
TableList just before starting a transaction ?

Eduardo

Mon, Oct 30 2006 1:01 PMPermanent Link

"Robert"

"Jose Eduardo Helminsky" <contato@hpro.com.br> wrote in message
news:18C1F4A4-37DD-4213-BB1B-C631CF523828@news.elevatesoft.com...
> Tim
>

Different threads? Assuming it is the same database, if it is the same
thread the transactions must be executed in sequence, so it should not be a
problem.

Robert


Mon, Oct 30 2006 1:42 PMPermanent Link

"Jose Eduardo Helminsky"
Robert

> Different threads? Assuming it is the same database, if it is the same
> thread the transactions must be executed in sequence, so it should not be
> a problem.
Another user executing the inverse order in other computer running on the
same database

Eduardo

Image