Java: JSONParseException

Question

All I'm trying to do is to parse very simple json line, even its valid i dont know why its throwing an error

the line is

com.mongodb.util.JSONParseException: 
{publish_status:'active',activation_date:{$lt:new Date()},expiration_date:{$gt:new Date()}}
                                               ^

what is wrong with the new Date() as a value?

@poitroae I'm trying to get the records that has activation date less than now and expiration date grater than now ... — Hilmi
– Hilmi, Commented Mar 3, 2013 at 16:59

Ryan Stewart · Accepted Answer · 2013-03-03 15:10:02Z

3

That's not valid JSON at all. JSON syntax is defined on json.org, and it's always a string key with a value that's one of a string, number, boolean, null, array, or object. You're writing a Mongo query from Java. You should reformulate your question and retag appropriately.

answered Mar 3, 2013 at 15:10

Ryan Stewart

130k22 gold badges183 silver badges201 bronze badges

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

Comments

Daniele Armanasco · Accepted Answer · 2013-03-03 15:32:20Z

1

I tried using the new date() in mongo DB 2.2.3 directly and it worked .. it created a value of ISODate.

You may try using this:

{publish_status:'active',activation_date:new Date(),expiration_date:new Date()}

edited Mar 3, 2013 at 15:32

Daniele Armanasco

7,47110 gold badges46 silver badges58 bronze badges

answered Mar 3, 2013 at 15:10

ankit-jain

261 bronze badge

3 Comments

Hilmi Over a year ago

I need the $lt & $gt operators,

ankit-jain Over a year ago

Date date = new Date(); BasicDBObject query = new BasicDBObject(); query.put("expiration_date", BasicDBObjectBuilder.start("$gt",date).get()); query.put("activation_date", BasicDBObjectBuilder.start("$lt",date).get()); DBObject document = collection.findOne(query);

ankit-jain Over a year ago

Try out the above code .. i used Java 1.7 and mongo dB 2.2.3 and mongo driver as 2.10.1

Collectives™ on Stack Overflow

Java: JSONParseException

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related