Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locking mechanism on data dictionary update
Message
From
23/03/2011 11:49:01
 
 
To
23/03/2011 11:16:25
General information
Forum:
ASP.NET
Category:
Other
Environment versions
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01504666
Message ID:
01504683
Views:
35
>I'm not sure I quite understand the scenario you've laid out. Could you explain it differently and throw in a bit of code to help clear it up?

When I adjust the data dictionary, this may require to reload an item in the data dictionary collection I have. When doing that, for a fraction of a section, an item in the collection might not be available to an ongoing hit in progress. Because, I have four application pool instances for the Web site, while one hit is updated the data dictionary, another one might still be in progress. Thus, because the Data class makes use of the collection, it may generate an error in the related process. So, the only way I see to resolve that issue would be to verify in the Data class for the availability of the data dictionary. So, when the data dictionary will be in update mode, I will know about it in the Data class and wait for its availability. This, of course, will simply help to diminish to amount of potential situations, but it will probably resolve most of the potential ones. Because, even if the Data class detects that the data dictionary is available, during its process, it might become unavailable again. But, this is unlikely to happen because only one person can update the data dictionary. And, when that happens, it is usually one item at a time, giving the other hits in progress more than enough time to complete.

The perfect architecture to support such flexiblity would be to install a double lock mechanism. But, I am afraid of dead locking issue here.

Any comment on this type of situation?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform