Java mongoTemplate findOne query not returning results when id is String

Question

I have the below query to find MongoDB document using mongoTemplate. This is not returning any results when I search my Target using Id.

Query query = new Query(Criteria.where("id").is(String.valueOf(targetId)));
mongoTemplate.findOne(query, Target.class));

But the query works when I use any fields other than Id. Could someone help me to work this using Id.

Target class

@Data
@Document
public class Target {
    @Id
    private String id;
    /**
     * Name of the target
     */
    private String name;
}

DB document.

{
    "_id" : "5290d748e4",
    "name" : "Test Target"
}

Query By name is working fine.

Query query = new Query(Criteria.where("name").is("Test Target"));
mongoTemplate.findOne(query, Target.class));

pvpkiran · Accepted Answer · 2019-10-10 11:28:42Z

1

Based on the discussions here, it looks like this is not possible to achieve. You need to change the type in database as ObjectId.

If you cannot do that, you can do

mongoTemplate.getCollection("target").findOne(<targetId>)

But this will return a DBObject, You need to create Target instance from this

edited Oct 10, 2019 at 11:28

answered Oct 10, 2019 at 10:05

pvpkiran

27.2k13 gold badges106 silver badges149 bronze badges

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

7 Comments

Shamnad P S Over a year ago

This also doesnt work. The id field in mongodb is String. {'_id': "1234"}

pvpkiran Over a year ago

can you put your Target class also

Shamnad P S Over a year ago

But mongoTemplate.findById(targetId) works fine. I need this to work with findOne and updateFirst. Which are not working at the moment.

Shamnad P S Over a year ago

added Target class to the question.

pvpkiran Over a year ago

did u try this new Query(Criteria.where("_id").is(new ObjectId(targetId)));

|

Shamnad P S · Accepted Answer · 2019-10-11 11:17:09Z

1

I was able to get the required functionality by using MongoCollection.

MongoDatabase mongoDatabase = mongoTemplate.getDb();
MongoCollection<Document> targetCollection
                    = mongoDatabase.getCollection(mongoTemplate.getCollectionName(Target.class));
Document query = new Document();
query.put("_id", parkTargetId);
query.put("spots._id", parkingSpotId);

targetCollection.find(query);

answered Oct 11, 2019 at 11:17

Shamnad P S

1,1832 gold badges16 silver badges46 bronze badges

Collectives™ on Stack Overflow

Java mongoTemplate findOne query not returning results when id is String

2 Answers 2

7 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related