Provide thread/resource locking in order to protect
resources from being altered by multiple threads at the same time using
a db row update.
Inheritance Hierarchy
Quartz.Impl.AdoJobStoreAdoConstants
Quartz.Impl.AdoJobStoreStdAdoConstants
Quartz.Impl.AdoJobStoreDBSemaphore
Quartz.Impl.AdoJobStoreUpdateLockRowSemaphore
Quartz.Impl.AdoJobStoreUpdateLockRowSemaphoreMOT
Namespace: Quartz.Impl.AdoJobStore
Assembly: Quartz (in Quartz.dll) Version: 3.0.0
Syntax
C#
public class UpdateLockRowSemaphore : DBSemaphore
The UpdateLockRowSemaphore type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
 | UpdateLockRowSemaphore(IDbProvider) |
Initializes a new instance of the UpdateLockRowSemaphore class.
|
 | UpdateLockRowSemaphore(String, String, String, String, IDbProvider) | Initializes a new instance of the UpdateLockRowSemaphore class |
Properties
| Name | Description | |
|---|---|---|
 | AdoUtil | (Inherited from DBSemaphore.) |
| InsertSQL | (Inherited from DBSemaphore.) |
 | RequiresConnection |
This Semaphore implementation does use the database.
(Inherited from DBSemaphore.) |
| RetryCount | |
| SchedName | (Inherited from DBSemaphore.) |
| SchedulerNameLiteral | (Inherited from DBSemaphore.) |
| SQL | (Inherited from DBSemaphore.) |
| TablePrefix |
Gets or sets the table prefix.
(Inherited from DBSemaphore.) |
Methods
| Name | Description | |
|---|---|---|
| Equals | Determines whether the specified object is equal to the current object. (Inherited from Object.) |
| ExecuteSQL |
Execute the SQL that will lock the proper database row.
(Overrides DBSemaphoreExecuteSQL(Guid, ConnectionAndTransactionHolder, String, String, String, CancellationToken).) |
| Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
| GetHashCode | Serves as the default hash function. (Inherited from Object.) |
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
| ObtainLock |
Grants a lock on the identified resource to the calling thread (blocking
until it is available).
(Inherited from DBSemaphore.) |
| ReleaseLock |
Release the lock on the identified resource if it is held by the calling
thread.
(Inherited from DBSemaphore.) |
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
Fields
| Name | Description | |
|---|---|---|
  | SqlInsertLock | |
| SqlUpdateForLock |
Remarks
Note: This Semaphore implementation is useful for databases that do not support row locking via "SELECT FOR UPDATE" or SQL Server's type syntax.
As of Quartz.NET 2.0 version there is no need to use this implementation for SQL Server databases.
See Also