Is Optimistic locking is supported in Camunda?

How optimistic locking is supported in Camunda?

How versioning of tasks performed?

What is the exact use case of column “REV_” from tables like
SELECT * FROM ACT_RU_AUTHORIZATION ;
SELECT * FROM ACT_RU_BATCH ;
SELECT * FROM ACT_RU_CASE_EXECUTION ;
SELECT * FROM ACT_RU_CASE_SENTRY_PART ;
SELECT * FROM ACT_RU_EVENT_SUBSCR ;
SELECT * FROM ACT_RU_EXECUTION ;
SELECT * FROM ACT_RU_EXT_TASK ;
SELECT * FROM ACT_RU_VARIABLE ;
SELECT * FROM ACT_RU_EXT_TASK ;
SELECT * FROM ACT_RU_FILTER ;
SELECT * FROM ACT_RU_IDENTITYLINK ;
SELECT * FROM ACT_RU_INCIDENT ;
SELECT * FROM ACT_RU_JOB ;
SELECT * FROM ACT_RU_JOBDEF;
SELECT * FROM ACT_RU_METER_LOG;

SELECT * FROM ACT_RE_PROCDEF;
SELECT * FROM ACT_RE_DEPLOYMENT;
SELECT * FROM ACT_ID_USER;

Where can i find detailed description & use case for each columns in all the tables.

From the documentation I can find only Table level description. I didn’t found column level description.

Hi @aravindhrs,

Check out this docs section: https://docs.camunda.org/manual/7.9/user-guide/process-engine/transactions-in-processes/#optimistic-locking. It should answer your questions.

Cheers,
Thorben

Well explained.

What about the column level descriptions for each tables?

There is no documentation on that. You can have a look at the code how the columns are used, or ask specific questions in this forum, but we won’t be able to cover the entire schema here.

REV_
Version
Version Tag

Wanted to know the purpose of these 3 columns. And which column is used for optimistic locking ?

It’s REV_, see this subsection: https://docs.camunda.org/manual/7.9/user-guide/process-engine/transactions-in-processes/#internal-implementation-details. The other columns are for versioning of process definitions.