How to query documents using "_id" field in Java mongodb driver?

Question

I am trying to find documents in MongoDB by searching on "_id" key. My document looks like this-

{
  "_id" : ObjectId("4f693d40e4b04cde19f17205"),
  "hostname" : "hostnameGoesHere",
  "OSType" : "OSTypeGoesHere"
}

I am trying to search this document as-

ObjectId id= new ObjectId("4f693d40e4b04cde19f17205");        
BasicDBObject obj = new BasicDBObject();        
obj.append("_id", id);        
BasicDBObject query = new BasicDBObject();        
query.putAll(query);

But I get below error-

error: reference to putAll is ambiguous, both method putAll(Map) in BasicBSONObject and method putAll(BSONObject) in BasicBSONObject match
        query.putAll(query);

The append method of BasicDBObject supports (String Key, Value) and if I pass "_id" as String to this method, no documents are matched.

So my question is how do I pass "_id"?

Andrii Abramov · Accepted Answer · 2017-07-12 10:20:50Z

71

Not sure if others might be searching for answers on this topic, but here is the easiest way to search for a MongoDB record based on "_id". The MongoDB documentation is not updated and still shows ObjectId as being part of the com.mongodb package (it also generally does not give a lot of information on searching by ObjectId).

import org.bson.types.ObjectId;

public DBObject findDocumentById(String id) {

    BasicDBObject query = new BasicDBObject();
    query.put("_id", new ObjectId(id));

    DBObject dbObj = collection.findOne(query);
    return dbObj;
}

edited Jul 12, 2017 at 10:20

Andrii Abramov

10.9k12 gold badges81 silver badges107 bronze badges

answered Oct 8, 2012 at 20:09

Chris

7375 silver badges7 bronze badges

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

1 Comment

Stu_Dent Over a year ago

Is it outdated?

bogolyandras · Accepted Answer · 2017-11-09 10:57:57Z

34

For those who are seeking a more up to date method, especially with 3.4:

import com.mongodb.client.MongoCollection;
import com.mongodb.client.MongoDatabase;
import org.bson.Document;
import org.bson.types.ObjectId;

import static com.mongodb.client.model.Filters.eq;

//......
MongoCollection<Document> myCollection = database.getCollection("myCollection");
Document document = myCollection.find(eq("_id", new ObjectId("4f693d40e4b04cde19f17205"))).first();
if (document == null) {
    //Document does not exist
} else {
    //We found the document
}

answered Nov 9, 2017 at 10:57

bogolyandras

4364 silver badges7 bronze badges

3 Comments

neoexpert Over a year ago

can we use findOne here?

bogolyandras Over a year ago

I don't think that we can use that method anymore. That was part of the old API api.mongodb.com/java/2.14/com/mongodb/DBCollection.html The new is a slightly different one api.mongodb.com/java/3.0/com/mongodb/async/client/…

Stu_Dent Over a year ago

the eq is not applicable to 3.12?

Rich Benner · Accepted Answer · 2016-07-12 10:09:34Z

6

You can do this

 ObjectId id= new ObjectId("4f693d40e4b04cde19f17205");        
    BasicDBObject obj = new BasicDBObject();        
    obj.append("_id", id);        
    BasicDBObject query = new BasicDBObject();        
    query.putAll((BSONObject)query);

edited Jul 12, 2016 at 10:09

Rich Benner

8,1419 gold badges35 silver badges39 bronze badges

answered Jul 12, 2016 at 9:53

Nifras Nipy

1011 silver badge3 bronze badges

Comments

user11006286 · Accepted Answer · 2022-09-12 14:39:43Z

2

The more simple way to do this is:

Bson filter = Filters.eq("_id", new ObjectId("4f693d40e4b04cde19f17205"));
mongoConfig.getMongoTemplate().getCollection("myCollection").find(filter);

Reference here: https://www.baeldung.com/mongodb-query-documents-id

answered Sep 12, 2022 at 14:39

user11006286

Comments

Andrii Abramov · Accepted Answer · 2017-07-12 10:20:34Z

1

Solved it by using query as-

query.putAll((BSONObject)query);

edited Jul 12, 2017 at 10:20

Andrii Abramov

10.9k12 gold badges81 silver badges107 bronze badges

answered Mar 21, 2012 at 3:01

user837208

2,5777 gold badges38 silver badges57 bronze badges

Comments

Valentin Michalak · Accepted Answer · 2022-09-30 00:20:12Z

I found a way around, with a little bit more of code, requires a string representing the id to be found passed as argument.

import com.mongodb.client.MongoDatabase;
import com.mongodb.client.MongoClient;
import com.mongodb.client.MongoClients;
import com.mongodb.client.MongoCollection;
import com.mongodb.client.model.Filters;
import org.bson.conversions.Bson;
import org.bson.Document;
import org.bson.types.ObjectId;   

[...]

public static void findCustomerById(String id) {
    try (MongoClient mongoClient = MongoClients.create("mongodb://localhost:27017")) {
        MongoDatabase database = mongoClient.getDatabase("database_name");
        Bson filter = Filters.eq("_id", new ObjectId(id));
        MongoCollection<Document> collection = database.getCollection("customer");

        //Tries to find the document
        Document doc = collection. Find(filter).first();
        //prints the document
        System.out.println(doc.toJson());
    } catch (Exception e) {
        System.out.println("Error finding document");
        System.out.println("Error in: " + e.getMessage());
        e.printStackTrace();
    }

Michael · Accepted Answer · 2023-05-17 13:37:26Z

0

Don't forget to add the collectionName parameter if your class and collectionName don't match. I landed on this question because my _id query wasn't working even though it looked good at first blush.

answered May 17, 2023 at 13:37

Michael

1,19315 silver badges18 bronze badges

Comments

Shabbir Hussain · Accepted Answer · 2020-07-08 13:37:48Z

-2

You can try this snippet:

ObjectId id= new ObjectId("4f693d40e4b04cde19f17205");        
BasicDBObject obj = new BasicDBObject();        
obj.append("_id", id);        
BasicDBObject query = new BasicDBObject();        
query.putAll((BSONObject)obj);

edited Jul 8, 2020 at 13:37

Shabbir Hussain

2,7402 gold badges19 silver badges26 bronze badges

answered Jul 8, 2020 at 11:13

Srushti Maladkar

1

1 Comment

ray Over a year ago

How is this different from Nifras Nipy's answer?

Collectives™ on Stack Overflow

How to query documents using "_id" field in Java mongodb driver?

8 Answers 8

1 Comment

3 Comments

Comments

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

1 Comment

3 Comments

Comments

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related