Hi Marco,
I have load your data into Virtuoso 5.0.10.3037 instances on Mac OS X
and Windows and running the queries you provide I get the following:
Query:
http://localhost: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
Returns:
{ "head": { "link": [], "vars": ["mainName"] },
"results": { "distinct": false, "ordered": true, "bindings": [
{ "mainName": { "type": "literal", "xml:lang": "en", "value":
"lysine catabolic process" }} ] } }
Query:
http://localhost: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
Returns:
<?xml version="1.0" ?>
<sparql xmlns="http://www.w3.org/2005/sparql-results#";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://www.w3.org/2001/sw/DataAccess/rf1/
result2.xsd">
<head>
<variable name="mainName"/>
</head>
<results distinct="false" ordered="true">
<result>
<binding name="mainName"><literal xml:lang="en">lysine catabolic
process</literal></binding>
</result>
</results>
</sparql>
Thus I cannot recreate the problem, are these the results you would
expect ?
Is your server "http://www.mysparlendpoint.com:8890/"; not accessible
remotely as the server fails to load when I run it ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
On 9 Apr 2009, at 16:09, Marco Ocana wrote:
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>-------------------------------------------------------
-----------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-
com_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
