JSON.parse(sql) error

XMLWordPrintableJSON

    • Type: Task
    • Resolution: Done
    • Priority: Blocker - P1
    • None
    • Affects Version/s: 2.7.2
    • Component/s: API
    • None
    • Environment:
      myexclipse ,win7 ,tomcat6.0
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      String sql="{aggregate:\"cms_article\",pipeline:[{$match:{$and:[{\"_id\":{$ne:\"\"}},{\"editor\":{$regex:/sys/}}]}},{$sort:{\"ctrolTime\":1}},{$limit:1}]}";

      BasicDBObject bdr=(BasicDBObject)JSON.parse(sql);

      there is error .
      {aggregate:"cms_article",pipeline:[{$match:{$and:[{"_id":{$ne:""}},{"editor":{$regex:/sys/}}]}},{$sort:{"ctrolTime":1}},{$limit:1}]}
      ^
      at com.mongodb.util.JSONParser.parse(JSON.java:381)
      at com.mongodb.util.JSONParser.parseObject(JSON.java:414)
      at com.mongodb.util.JSONParser.parse(JSON.java:378)
      at com.mongodb.util.JSONParser.parseObject(JSON.java:414)
      at com.mongodb.util.JSONParser.parse(JSON.java:378)
      at com.mongodb.util.JSONParser.parseArray(JSON.java:718)
      at com.mongodb.util.JSONParser.parse(JSON.java:374)
      at com.mongodb.util.JSONParser.parseObject(JSON.java:414)
      at com.mongodb.util.JSONParser.parse(JSON.java:378)
      at com.mongodb.util.JSONParser.parseObject(JSON.java:414)
      at com.mongodb.util.JSONParser.parse(JSON.java:378)
      at com.mongodb.util.JSONParser.parseArray(JSON.java:718)
      at com.mongodb.util.JSONParser.parse(JSON.java:374)
      at com.mongodb.util.JSONParser.parseObject(JSON.java:414)
      at com.mongodb.util.JSONParser.parse(JSON.java:378)
      at com.mongodb.util.JSONParser.parse(JSON.java:328)
      at com.mongodb.util.JSON.parse(JSON.java:287)
      at com.mongodb.util.JSON.parse(JSON.java:272)
      at com.gold169.mongodb.util.MongoDbUtil.reverseJsonFromOri(MongoDbUtil.java:267)
      at test.Testt.main(Testt.java:97)

            Assignee:
            Unassigned
            Reporter:
            fanyongdong
            None
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: