Transaction lock in MongoDB?

Transaction support isn’t available in MongoDB 4.0. To get similar results, use findOneAndUpdate().

Let us create a collection with documents −

> db.demo404.insertOne({"FirstName":"John"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e6f8c38fac4d418a0178592")
}
> db.demo404.insertOne({"FirstName":"Robert"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e6f8c3cfac4d418a0178593")
}
> db.demo404.insertOne({"FirstName":"Mike"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e6f8c40fac4d418a0178594")
}

Display all documents from a collection with the help of find() method −

> db.demo404.find();

This will produce the following output −

{ "_id" : ObjectId("5e6f8c38fac4d418a0178592"), "FirstName" : "John" }
{ "_id" : ObjectId("5e6f8c3cfac4d418a0178593"), "FirstName" : "Robert" }
{ "_id" : ObjectId("5e6f8c40fac4d418a0178594"), "FirstName" : "Mike" }

Following is the query to use findOneAndUpdate and set lock in MongoDB −

> result=db.demo404.findOneAndUpdate({"in_transaction": {"$exists": false}}, {"$set": {"in_transaction": true}});

This will produce the following output −

{ "_id" : ObjectId("5e6f8c38fac4d418a0178592"), "FirstName" : "John" }

AmitDiwan

Updated on 03-Apr-2020 12:47:17

• Related Questions & Answers
• Checking transaction list waiting for lock-in SAP HANA
• MongoDB transaction & indexes for duplicate values
• Object level lock vs Class level lock in Java?
• Differentiate between cash transaction and credit transaction
• Difference between Object level lock and Class level lock in Java
• Use ReaderWriter Lock in C#
• States of Transaction in DBMS
• Properties of Transaction in DBMS
• Definition of Transaction in Database
• What is transaction processing? Explain the properties of the transaction(DBMS)
• Check if Caps Lock and Num Lock is on or off through Console in C#
• Which statement, other than START TRANSACTION, is used for starting a transaction?
• What will happen to the current MySQL transaction if a START TRANSACTION command is executed in the middle of that current transaction?
• Defining user lock settings in SAP HANA
• How to lock multiple tables in MySQL?