Uploaded image for project: 'Java Driver'
  1. Java Driver
  2. JAVA-751

JSON.parse(sql) error

    XMLWordPrintableJSON

Details

    • Icon: Task Task
    • Resolution: Done
    • Icon: Blocker - P1 Blocker - P1
    • None
    • 2.7.2
    • API
    • None
    • myexclipse ,win7 ,tomcat6.0

    Description

      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)

      Attachments

        Activity

          People

            Unassigned Unassigned
            fyddaben fanyongdong
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: