How to add an array to a MongoDB document using Java?

Question

I want to create the following document schema in mongoDB using the java driver

{
  "_id": {
    "$oid": "513e9820c5d0d8b93228d7e8"
  },
  "suitename": "testsuite_name",
  "testname": "testcase_name",
  "milestones": [
    {
      "milestone_id": "359",
      "testplans": [
        {
          "pland_id": "965",
          "runs": [
            6985,
            5896
          ]
        },
        {
          "plan_id": "984",
          "runs": [
            9856,
            3684
          ]
        }
      ]
    }
  ]
}

I have the following code

BasicDBObject testObject = new BasicDBObject();
BasicDBObject milestoneObject = new BasicDBObject();

testObject.put("suitename", testsuite);
testObject.put("testname", testcase);
testObject.put("milestones", new BasicDBObject("milestone_id", "2333"));
locations.insert(testObject);

But this is not generating milestone as an array. How can I add milestone as an array? I currently get this using my code

{
  "_id": {
    "$oid": "513f93dac5d0e2439d34308e"
  },
  "suitename": "test_deployment_disable_client.TestDeploymentDisableClient",
  "testname": "test_deployment_disable_client",
  "milestones": {
    "milestone_id": "2333"
  }
}

thatWiseGuy · Accepted Answer · 2015-12-10 23:52:39Z

43

Change to something like this:

testObject.put("suitename", testsuite);
testObject.put("testname", testcase);         
List<BasicDBObject> milestones = new ArrayList<>();
milestones.add(new BasicDBObject("milestone_id", "2333"));
testObject.put("milestones", milestones);
locations.insert(testObject);

edited Dec 10, 2015 at 23:52

thatWiseGuy

4202 gold badges5 silver badges20 bronze badges

answered Mar 12, 2013 at 21:08

Ori Dar

19.1k5 gold badges61 silver badges76 bronze badges

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

Comments

vjrocks5503 · Accepted Answer · 2015-06-19 19:34:39Z

5

You can create an ArrayList which takes in DBObjects.

List<DBObject> array = new ArrayList<DBObject>();

Add the created DBObject for the object inside the array and add it to the array object created.

array.add(/* some object */);

Finally, put the array in the main document object.

document.put("milestones", array);

edited Jun 19, 2015 at 19:34

answered Jun 19, 2015 at 19:26

vjrocks5503

511 silver badge2 bronze badges

Comments

HDJEMAI · Accepted Answer · 2017-06-10 14:22:22Z

1

Better use:

MongoClient client = new MongoClient("localhost",27017);

MongoCollection<Document> collection =        client.getDatabase("db").getCollection("collection");

List<Document> docs=new ArrayList<>();
docs.add();

collection.insertMany(docs);

client.close();

edited Jun 10, 2017 at 14:22

HDJEMAI

9,85048 gold badges78 silver badges99 bronze badges

answered Jun 10, 2017 at 14:01

Shiv Krishna Jaiswal

3867 silver badges12 bronze badges

Comments

Devraj Giri · Accepted Answer · 2019-03-08 18:31:50Z

0

Little extending to previous answer

    BasicDBObject testObject = new BasicDBObject();
    testObject.put("type", "milestones");
    testObject.put("usecase", "milestone_type");

    List<BasicDBObject> testplans = new ArrayList<>();
    testplans.add(new BasicDBObject("plan_id","3232"));
    testplans.add(new BasicDBObject("plan_day","sunday"));


    BasicDBObject milestoneObject = new BasicDBObject();
    milestoneObject.put("milestone_id", "3232");
    milestoneObject.put("plans", testplans);


    List<BasicDBObject> milestones = new ArrayList<>();
    milestones.add( milestoneObject);
    testObject.put("milestones", milestones);


    locations.insert(testObject);

edited Mar 8, 2019 at 18:31

answered Oct 16, 2018 at 14:33

Devraj Giri

214 bronze badges

Collectives™ on Stack Overflow

How to add an array to a MongoDB document using Java?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related