Java MongoDB cannot query with String criteria in collection

Question

I have a collection in DB and can get it to a DBCollection just fine. But when I try to query it with a String field, it doesn't return any result.

However, when I query with an Integer field, that query returns results for the same dataset.

Here are my trials:

// It doesn't work this way, cursor has nothing
DBObject allQuery = new BasicDBObject();
allQuery.put("data", "someName");
List cursor = collection.find(allQuery).toArray();


// This time it works, only change is that I query with an Integer value now
DBObject allQuery = new BasicDBObject();
allQuery.put("xyz", 1);
List cursor = collection.find(allQuery).toArray();

This is the collection returned from DB:

{ "_id" : { "$oid" : "574c780aa8268280d1b53162"} , "id" : 1 , "name" : "\"Some name\"" , "city" : "\"Ankara\"" , "country" : "\"Turkey\""}

I suspect those String representations with "\" characters but couldn't find any workaround to it either.

I've checked dozens of articles and also MongoDB documentation but there seems to be nothing special about this. But interestingly it doesn't work.

Hope you can show me a way to get around this. Thank you.

shmosel · Accepted Answer · 2016-05-30 22:24:43Z

2

Your string values are enclosed in quotes. If you're not able to change that, you can include the quotes in your query:

allQuery.put("iata", "\"BOS\"");

answered May 30, 2016 at 22:24

shmosel

51.1k7 gold badges82 silver badges147 bronze badges

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

5 Comments

neocorp Over a year ago

When I've inserted, I've just simply pushed a List<DBObject> to DB, why do those quotes exists?

shmosel Over a year ago

@NiyaziErdogan How are those objects generated?

neocorp Over a year ago

I read them from a CSV file and add to a list without a single modification.

shmosel Over a year ago

@NiyaziErdogan There are a few problems with your code. For one thing, it will fail on strings containing commas. For another, it ignores the fact that CSV values can be enclosed in quotes. Use a proper CSV parser and your problems will go away.

neocorp Over a year ago

thank you for your suggestion and time @shmosel I'll approve your answer anyway.

Collectives™ on Stack Overflow

Java MongoDB cannot query with String criteria in collection

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related