Unable to update Inner Arraylist object using Mongodb Java Driver

Question

I have below document structure in mongodb database:

{
    "_id" : ObjectId("52ec7b43e4b048cd48499b35"),
    "eidlist" : [
        {
            "eid" : "64286",
            "dst" : NumberLong(21044),
            "score" : 0
        },
        {
            "eid" : "65077",
            "dst" : NumberLong(21044),
            "score" : 0
        }
    ],
    "src" : NumberLong(21047)
}

I would like to update score field of first object using Java-mongodb driver: I tried following code but it is not working :( :

  DBObject update_query=new BasicDBObject("src", key).append("eidlist.eid", e.getEdgeid());
  DBObject data=new BasicDBObject("$set",new BasicDBObject("eidlist.score",100));
 coll.update(update_query, data);

Please help me to solve this problem..I have checked all the parameter which I have passed to update function.I think something wrong with the update logic :(

did you run a findOne with the update query just to make sure you're getting the document you expect? — brwngrldev
– brwngrldev, Commented Feb 1, 2014 at 19:52
@adavis: Yes I tried with findOne and this record is exist in the database. — Galaxy
– Galaxy, Commented Feb 2, 2014 at 7:10

Neil Lunn · Accepted Answer · 2014-02-01 22:40:42Z

2

You were close. You omiited the positional operator from the update. Edit your code as shown.

DBObject data=new BasicDBObject("$set",new BasicDBObject("eidlist.$.score",100));

answered Feb 1, 2014 at 22:40

Neil Lunn

151k36 gold badges356 silver badges327 bronze badges

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

2 Comments

Galaxy Over a year ago

I am sorry your solution was right. I got the problem it's in data type. In database "eidlist.$.score" field is string and I am passing integer value in the update query.. :)

Neil Lunn Over a year ago

Aha. I was too quick and didn't look at that either. Good pick up.

Galaxy · Accepted Answer · 2014-02-02 07:23:58Z

0

Solution for this problem is:

DBObject data=new BasicDBObject("$set",new BasicDBObject("eidlist.$.score",""+100));

Ensure data type of every field used in the update query.It should be compatible with what we have stored in the mongodb :)

answered Feb 2, 2014 at 7:23

Galaxy

8631 gold badge10 silver badges27 bronze badges

Collectives™ on Stack Overflow

Unable to update Inner Arraylist object using Mongodb Java Driver

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related