$lock
Locks and unlocks an entity using the pessimistic mechanism.
Syntax
To lock an entity for other sessions and 4D processes:
/?$lock=true
To unlock the entity for other sessions and 4D processes:
/?$lock=false
The lockKindText
property is "Locked by session".
Description
The locks triggered by the REST API are put at the session level.
A locked entity is seen as locked (i.e. lock / unlock / update / delete actions are not possible) by:
- other REST sessions
- 4D processes (client/server, remote datastore, standalone) running on the REST server.
An entity locked by the REST API can only be unlocked:
- by its locker, i.e. a
/?$lock=false
in the REST session that sets/?$lock=true
- or if the session's inactivity timeout is reached (the session is closed).
Response
A ?$lock
request returns a JSON object with "result"=true
if the lock operation was successful and "result"=false
if it failed.
The returned "__STATUS" object has the following properties:
Property | Type | Description | |
---|---|---|---|
Available only in case of success: | |||
success | boolean | true if the lock action is successful (or if the entity is already locked in the current session), false otherwise (not returned in this case). | |
Available only in case of error: | |||
status | number | Error code, see below | |
statusText | text | Description of the error, see below | |
lockKind | number | Lock code | |
lockKindText | text | "Locked by session" if locked by a REST session, "Locked by record" if locked by a 4D process |
The following values can be returned in the status and statusText properties of the __STATUS object in case of error:
status | statusText | Comment |
---|---|---|
2 | "Stamp has changed" | The internal stamp value of the entity does not match the one of the entity stored in the data (optimistic lock). |
3 | "Already locked" | The entity is locked by a pessimistic lock. |
4 | "Other error" | A serious error is a low-level database error (e.g. duplicated key), a hardware error, etc. |
5 | "Entity does not exist anymore" | The entity no longer exists in the data. |
Example
We lock an entity in a first browser:
GET /rest/Customers(1)/?$lock=true
Response:
{
"result": true,
"__STATUS": {
"success": true
}
}
In a second browser (other session), we send the same request.
Response:
{
"result":false,
"__STATUS":{
"status":3,
"statusText":"Already Locked",
"lockKind":7,
"lockKindText":"Locked By Session",
}
}