Mongo Query with $in array in Java

Question

I am trying to create this query from Java for MongoDB. Do you know how can I construct it in java?

db.node.find({
 connectedWithIds: { $in: [ 
     ObjectId('56bca32fe74a987ad8724da1')       
     ] }
})

I tried to use this:

ObjectId arr[] = {new ObjectId("5409ae2e2cdc31c5aa0ce0a5")};
BasicDBObject inQuery = new BasicDBObject("$in", arr);
BasicDBObject query = new BasicDBObject("connectedWithIds", inQuery);

but the results is below:

{ "connectedWithIds" : { "$in" : [ { "$oid" : "5409ae2e2cdc31c5aa0ce0a5"}]}}

and occurs this error:

error: {
    "$err" : "Can't canonicalize query: BadValue cannot nest $ under $in",
    "code" : 17287
}

eddie · Accepted Answer · 2016-08-24 22:26:18Z

1

I could overcome this error with the code below:

    ArrayList<ObjectId> vals = new ArrayList<ObjectId>();
    vals.add(objectId);       
    BasicDBObject inQuery = new BasicDBObject("$in", vals);
    BasicDBObject query = new BasicDBObject("connectedWithIds", inQuery);
    List<BasicDBObject> users = (List<BasicDBObject>) customQueryManager.executeQuery("node", query);

edited Aug 24, 2016 at 22:26

eddie

1,2503 gold badges15 silver badges20 bronze badges

answered Feb 12, 2016 at 20:16

pik4

1,3734 gold badges23 silver badges62 bronze badges

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

Collectives™ on Stack Overflow

Mongo Query with $in array in Java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related