How to access MongoDB document as JSONObject in spring boot application

Question

I have documents like below in a collection named event in mongoDB

{
    "name": "pick",
    "message": {
        "word": "seven",
        "sequenceNumber": 34
    }
}

which existed before I developed my Spring Boot application to access it. Now I have a java object Event.java to access the above collection.

public class Event{
    private String name;
    private JSONObject messgae;
    // getters setters costructors
}

In the document, the message could be any json. So defining a class for message does not make any sense. I have tried using mongoOperations, mongoTemplate and mongoRepository but I am not able to access the the document and change the value and store it again. The problems I face are,

I could not use JSONObject for message because mongoOperations has no support
I could not use String for message because when I save the object again it gets serialized like "message":"{\"word ...

Is there any way I can access, modify and store the data via spring boot application?

abaghel · Accepted Answer · 2017-08-24 06:38:58Z

1

You can use JSONObject for message in mongoOperations like below.

JSONObject jsonObj= new JSONObject();
jsonObj.put("word", "seven");
jsonObj.put("sequenceNumber", new Integer(34));

//save
Event eventDocument = new Event("pick",jsonObj);
mongoOperations.save(eventDocument);

//find
Query query = new Query(Criteria.where("name").is("pick"));
Event object = (Event) mongoOperations.findOne(query, Event.class);
System.out.println(object.getName());
System.out.println(object.getMessage());

edited Aug 24, 2017 at 6:38

answered Aug 24, 2017 at 6:29

abaghel

15.4k2 gold badges56 silver badges69 bronze badges

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

3 Comments

Rene Enriquez Over a year ago

What's the full class name? is JSONObject from an external library?

abaghel Over a year ago

org.json.JSONObject from mvnrepository.com/artifact/org.json/json/20180130

Rene Enriquez Over a year ago

Thanks, I did using json-simple, it worked like a charm

Collectives™ on Stack Overflow

How to access MongoDB document as JSONObject in spring boot application

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related