How to run MongoDB native query (JSON) using Mongo-Java Driver?

Question

I want to run below native Queries in my java project using DB.runCommand()

Query1:

db.test_temp.insert({entityId:2,columnName1:"columnName2.1",columnName2:"columnName2.2"})

Query 2:

db.test_temp.updateOne(
   { columnName1: "columnName1" },
   {
     $set: { "columnName1": "columnName1.0" }
   }
);

My code:

String json="db.test_temp.insert({entityId:2,columnName1:"columnName2.1",columnName2:"columnName2.2"}";
Bson command = new Document("eval",json); 
db.runCommand(command);

I also tried from How to execute MongoDB native query (JSON) using mongo-java-driver only? but it's not working

Error:

com.mongodb.MongoCommandException: Command failed with error 13

Edgar Khachatryan · Accepted Answer · 2020-12-23 14:31:29Z

0

As said in your mentioned link `

eval command is deprecated and its usage is not advised

According to this answer, you can do as follows

String json = "{insert : 'collectionName', documents : [{entityId:2,columnName1:'columnName2.1',columnName2:'columnName2.2'}]}";
Document bsonCmd = Document.parse(json);
Document result = db.runCommand(bsonCmd);

Please check insert command syntax in insert docs

edited Dec 23, 2020 at 14:31

answered Dec 23, 2020 at 14:23

Edgar Khachatryan

3133 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

How to run MongoDB native query (JSON) using Mongo-Java Driver?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related