Bulk Read: Unable to use a JSON QBE

[kcoleman-marklogic]

If I try to perform a bulk read using a JSON QBE, the server returns REST-REPEATEDPARAM. Seems like the request is not being properly constructed. An equivalent read using an XML QBE works as expected. See next comment for sample code.

Exception in thread "main" com.marklogic.client.FailedRequestException: Local message: search failed: Bad Request. Server Message: REST-REPEATEDPARAM: (rest:REPEATEDPARAM) Endpoint does not support repeated parameter: format can only appear once
at com.marklogic.client.impl.JerseyServices$JerseySearchRequest.getResponse(JerseyServices.java:2074)
at com.marklogic.client.impl.JerseyServices.getBulkDocumentsImpl(JerseyServices.java:775)
at com.marklogic.client.impl.JerseyServices.getBulkDocuments(JerseyServices.java:715)
at com.marklogic.client.impl.DocumentManagerImpl.search(DocumentManagerImpl.java:371)
at com.marklogic.client.impl.JSONDocumentImpl.search(JSONDocumentImpl.java:1)
at com.marklogic.client.impl.DocumentManagerImpl.search(DocumentManagerImpl.java:342)
at com.marklogic.client.impl.JSONDocumentImpl.search(JSONDocumentImpl.java:1)
at examples.ReadExamples.qbeExample(ReadExamples.java:64)
at examples.ReadExamples.main(ReadExamples.java:101)

[kcoleman-marklogic]

// Sample code demonstrating the problem
package examples;

import com.marklogic.client.io.*;
import com.marklogic.client.query.QueryManager;
import com.marklogic.client.query.RawQueryByExampleDefinition;
import com.marklogic.client.document.JSONDocumentManager;
import com.marklogic.client.document.XMLDocumentManager;
import com.marklogic.client.DatabaseClientFactory;
import com.marklogic.client.DatabaseClient;
import com.marklogic.client.document.DocumentPage;
import com.marklogic.client.document.DocumentRecord;


public class ReadExamples {
    // replace with your MarkLogic Server connection information
    static String HOST = "localhost";
    static int PORT = 8003;
    static String USER = "user";
    static String PASSWORD = "password";
    static  DatabaseClient client = DatabaseClientFactory.newClient(
            HOST, PORT, 
            USER, PASSWORD, 
            DatabaseClientFactory.Authentication.DIGEST);

    public static void qbeExample() {
        JSONDocumentManager jdm = client.newJSONDocumentManager();
        QueryManager qm = client.newQueryManager();
        String queryAsString = "{ \"$query\": { \"kind\": \"bird\" }    }";
        StringHandle handle = new StringHandle();
        handle.withFormat(Format.JSON).set(queryAsString);      
        RawQueryByExampleDefinition query = 
                qm.newRawQueryByExampleDefinition(handle);

        StringHandle report = qm.validate(query, new StringHandle());
        System.out.println(report.toString());

        DocumentPage documents = jdm.search(query, 1);
        while (documents.hasNext()) {
            DocumentRecord document = documents.next();
            System.out.print(document.getUri() + ": ");
            StringHandle content = document.getContent(new StringHandle());
            System.out.println(content.toString());
        }
    }

        // this works, provided just for contrast
    public static void xmlExample() {
        XMLDocumentManager xdm = client.newXMLDocumentManager();
        QueryManager qm = client.newQueryManager();
        String queryAsString = 
            "<q:qbe xmlns:q='http://marklogic.com/appservices/querybyexample'>"+
                "<q:query>" +
                  "<kind>bird</kind>" +
                "</q:query>" +
              "</q:qbe>";
        RawQueryByExampleDefinition query = 
                qm.newRawQueryByExampleDefinition(new StringHandle(queryAsString));

        StringHandle report = qm.validate(query, new StringHandle());
        System.out.println(report.toString());

        DocumentPage documents = xdm.search(query, 1);
        while (documents.hasNext()) {
            DocumentRecord document = documents.next();
            System.out.println(document.getUri() + ": ");
            StringHandle content = document.getContent(new StringHandle());
            System.out.println(content.toString());
        }
    }


    public static void main(String[] args) {
        qbeExample();
        //xmlExample();
    }
}

[kcoleman-marklogic]

Stupid XQuery tricks: This is the query I used to generate the content against which I ran the JSON example. Splat it into QC to populate the database. I have an equivalent XML query; if you want it, let me know.

xquery version "1.0-ml";
declare namespace html = "http://www.w3.org/1999/xhtml";

let $animals :=
(
object-node { "animal" : object-node { "name": "aardvark", "kind": "mammal" } },
object-node { "animal" : object-node { "name": "badger", "kind": "mammal" } },
object-node { "animal" : object-node { "name": "camel", "kind": "mammal" } },
object-node { "animal" : object-node { "name": "duck", "kind": "bird" } },
object-node { "animal" : object-node { "name": "emu", "kind": "bird" } },
object-node { "animal" : object-node { "name": "fox", "kind": "mammal" } },
object-node { "animal" : object-node { "name": "goose", "kind": "bird" } },
object-node { "animal" : object-node { "name": "hare", "kind": "mammal" } },
object-node { "animal" : object-node { "name": "ibex", "kind": "bird" } },
object-node { "animal" : object-node { "name": "jaguar", "kind": "mammal" } },
object-node { "animal" : object-node { "name": "kangaroo", "kind": "marsupial" } },
object-node { "animal" : object-node { "name": "lemur", "kind": "mammal" } },
object-node { "animal" : object-node { "name": "moose", "kind": "mammal" } },
object-node { "animal" : object-node { "name": "nighthawk", "kind": "bird" } },
object-node { "animal" : object-node { "name": "ocelot", "kind": "mammal" } },
object-node { "animal" : object-node { "name": "panda", "kind": "mammal" } },
object-node { "animal" : object-node { "name": "rhino", "kind": "mammal" } },
object-node { "animal" : object-node { "name": "snake", "kind": "reptile" } },
object-node { "animal" : object-node { "name": "turtle", "kind": "reptile" } },
object-node { "animal" : object-node { "name": "urial", "kind": "mammal" } },
object-node { "animal" : object-node { "name": "vulture", "kind": "bird" } },
object-node { "animal" : object-node { "name": "wallaby", "kind": "marsupial" } },
object-node { "animal" : object-node { "name": "yak", "kind": "mammal" } },
object-node { "animal" : object-node { "name": "zebra", "kind": "mammal" } }
)
for $a in ($animals)
return
  xdmp:document-insert(fn:concat("/animals/", $a//name, ".json"), $a)

[kcoleman-marklogic]

It's not beyond possibility that this is related to #29 , but it doesn't really feel like it.