MongoDB+Java - parsing JSON via com.mongodb.util.JSON.parse

Question

I am using com.mongodb.util.JSON.parse to parse a JSON file to DBObject. How do I specify dates, refs, and objects IDs in the JSON file?

Remon van Vliet · Accepted Answer · 2011-10-17 10:52:40Z

8

Dates : { myDate: {$date: "yyyy-MM-dd'T'HH:mm:ss.SSS'Z'" } } // Date in the mentioned ISODate string format.

Refs : { myRef : { $ref : <collname>, $id : <idvalue>[, $db : <dbname>] } } // collname is collection name, idvalue is the _id of the referred document and optionally dbname is the database the document is in.

ObjectIds : { _id : {$oid: "4e942f36de3eda51d5a7436c"} }

edited Oct 17, 2011 at 10:52

answered Oct 11, 2011 at 11:58

Remon van Vliet

18.6k3 gold badges54 silver badges57 bronze badges

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

4 Comments

jeffreyveon Over a year ago

Can you please explain what you mean by a parseable string?

Remon van Vliet Over a year ago

Any particular reason why you unaccepted. The information above is accurate.

jeffreyveon Over a year ago

Sorry, I meant to follow up. I have accepted the answer, but I am facing an issue. The Java library expects the data to be in the ISO date format (as a string), and not as a long as given above. When I use the long format, I get a JSON parse exception.

Remon van Vliet Over a year ago

@jeffreyveon. Ah, yes, my apologies. The JSON.parse method expects the date as a string in the "yyyy-MM-dd'T'HH:mm:ss.SSS'Z'" format. I'll edit my answer

Collectives™ on Stack Overflow

MongoDB+Java - parsing JSON via com.mongodb.util.JSON.parse

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related