AWS DynamoDb with Optimistic Locking and Batch Write Operations

Question

Can we use DynamoDb optimistic locking with batchWriteItem request? AWS docs on Optimistic locking mention that a ConditionalCheckFailedException is thrown when the version value is different while updating the request. In case of batchWriteItem request, will the whole batch fail or only that record with a different version value? Will the record that failed due to different version value be returned as an unprocessed record?

hunterhacker · Accepted Answer · 2022-08-05 04:44:45Z

3

You cannot. You can be sure by looking at the low level syntax and notice there’s no ability to specify a condition expression.

https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_BatchWriteItem.html

answered Aug 5, 2022 at 4:44

hunterhacker

7,2801 gold badge18 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mike Reddington Over a year ago

For optimistic locking we don't need to specify conditional check, DynamoDB will throw this exception if the version number in the write request is not the same as the one stored in db. What I wanted to know is if DynamoDB supports optimistic locking for each individual write item request in the batchWriteItem request or not.

hunterhacker Over a year ago

The Java SDK has to use the conditional expression functionality to achieve that optimistic locking behavior. Since the wire protocol doesn’t support it, Java can’t do it.

Collectives™ on Stack Overflow

AWS DynamoDb with Optimistic Locking and Batch Write Operations

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related