MongoCollection to JSON array

Question

After going through tons of examples, I couldn't find relevant code, Basically I want to serialize the JSON array over the wire to the client.

MongoCursor<Document> cursor = ((MongoCollection)data).find().iterator();
try {
    while (cursor.hasNext()) {
        response.getWriter().write(cursor.next().toJson());
    }
} catch (IOException e) {
    e.printStackTrace();
} finally {
    cursor.close();
}
break;

Attempt Doesn't work but is something close to what I'm looking for.

MongoCursor<Document> cursor = ((MongoCollection)data).find().iterator();
JsonWriter jsonWriter = new JsonWriter(response.getWriter());
jsonWriter.writeStartDocument();
jsonWriter.writeStartArray();

while(cursor.hasNext()) {
    jsonWriter.writeStartDocument();
    jsonWriter.writeString(cursor.next().toJson());
    jsonWriter.writeEndDocument();
}

jsonWriter.writeEndArray();
jsonWriter.writeEndDocument();

cursor.close();

Any serialization solutions for mongodb collections?

Naive way works

try {
    response.getWriter().write("[");
    while (cursor.hasNext()) {
        response.getWriter().write(cursor.next().toJson() + (cursor.hasNext() ? "," : ""));
    }
    response.getWriter().write("]");
} finally {
    cursor.close();
}

Ben Benson · Accepted Answer · 2019-07-29 09:43:16Z

1

I'm using com.fasterxml.jackson.databind.ObjectMapper for this purpose.

answered Jul 29, 2019 at 9:43

Ben Benson

3363 silver badges4 bronze badges

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

1 Comment

HelloWorld Over a year ago

I'm trying to find oracle json library solution

Vokail · Accepted Answer · 2019-10-01 10:01:24Z

0

I assume your desired output value is not an "infinite json", otherwise put in place some kind of pagination.

Basically with java mongo driver you have a org.bson.Document class, and with method toJson you create a string with inside Json for your Document, reference: https://api.mongodb.com/java/3.2/org/bson/Document.html#toJson--

Note: basic encoder take care of handling arrays for you

answered Oct 1, 2019 at 10:01

Vokail

7009 silver badges32 bronze badges

Collectives™ on Stack Overflow

MongoCollection to JSON array

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related