Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
Restricted transaction |
Mon, Oct 30 2006 12:25 PM | Permanent 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 PM | Permanent 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 PM | Permanent 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 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |