Hi, I am running Virtuoso open-source edition Version 5.0.10.3037 on Windows XP 32-Bit. I imported a subset of the GO Ontology, OWL version using the WebDAV mechanism in the Conductor. When I use the SPARQL endpoint to do some simple queries, the HTML table format returns to the browser the expected results. However, if I specify the json format or xml format in the query URL, I get errors. Any help resolving this problem would be greatly appreciated. Below are the details.
Marco Ocana Balboa Systems, Inc. I have attached a subset of my dataset (about 70 triples) that reproduces the problem. These I imported into a graph called: http://goOneProcess.com The unescaped query: prefix obo: <http://purl.org/obo/owl/GO#> prefix goformat: <http://www.geneontology.org/formats/oboInOwl#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> select ?mainName FROM <http://goOneProcess.com> where { obo:GO_0006554 rdfs:label ?mainName. } The query URLs (json and xml, in order): http://www.mysparlendpoint.com:8890/sparql/?query=%0Aprefix%20obo%3A%20%3Chttp%3A//purl.org/obo/owl/GO%23%3E%0Aprefix%20goformat%3A%20%3Chttp%3A//www.geneontology.org/formats/oboInOwl%23%3E%0Aprefix%20rdfs%3A%20%3Chttp%3A//www.w3.org/2000/01/rdf-schema%23%3E%0Aselect%20%3FmainName%0AFROM%20%3Chttp%3A//goOneProcess.com%3E%0Awhere%20{%0Aobo%3AGO_0006554%0Ardfs%3Alabel%20%3FmainName.%0A}&format=xml http://www.mysparlendpoint.com:8890/sparql/?query=%0Aprefix%20obo%3A%20%3Chttp%3A//purl.org/obo/owl/GO%23%3E%0Aprefix%20goformat%3A%20%3Chttp%3A//www.geneontology.org/formats/oboInOwl%23%3E%0Aprefix%20rdfs%3A%20%3Chttp%3A//www.w3.org/2000/01/rdf-schema%23%3E%0Aselect%20%3FmainName%0AFROM%20%3Chttp%3A//goOneProcess.com%3E%0Awhere%20{%0Aobo%3AGO_0006554%0Ardfs%3Alabel%20%3FmainName.%0A}&format=json In the json case, the error: { "head": { "link": [], "vars": ["mainName"] }, "results": { "distinct": false, "ordered": true, "bindings": [ { "mainName": { "type": "literal", "xml:lang": "22023 Error SR460: Function http_escape needs a varbinary or varchar argument 1 with length more than zero, not an arg of type DB_NULL (204) In the xml case: <?xml version="1.0" ?> <head> <variable name="mainName"/> </head> <results distinct="false" ordered="true"> <result>RDFXX Error Unknown language in DB.DBA.RDF_LANGUAGE_OF_LONG, bad id 258
go0006554.rdf
Description: application/rdf
