I got rid of my error:
SR575: No permission to execute DB.DBA.TTLP_EV_NEW_GRAPH as callback of
rdf_load_turtle()
after I executed via isql:
GRANT EXECUTE ON DB.DBA.RDF_SPONGE_UP TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON DB.DBA.TTLP_EV_NEW_GRAPH TO "SPARQL", "SPARQL_UPDATE";
grant SPARQL_UPDATE to "SPARQL";
Thanks again, very helpful!
- Erich
On 01/22/13 7:11 PM, Hugh Williams wrote:
Hi Alexey,
OK, good to hear you got it working. We are going to publish some
usage examples on how to perform such queries ...
I quickly got your sample data loaded using curl as follows:
$ more test.ttl
@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
@prefix owl: <http://www.w3.org/2002/07/owl#> .
@prefix skos: <http://www.w3.org/2004/02/skos/core#> .
@prefix dcam: <http://purl.org/dc/dcam/> .
@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
<http://purl.org/dc/dcam/>
dcterms:modified
"2012-06-14"^^<http://www.w3.org/2001/XMLSchema#date> ;
dcterms:publisher <http://purl.org/dc/aboutdcmi#DCMI> ;
dcterms:title "Metadata terms related to the DCMI Abstract Model"@en .
dcam:VocabularyEncodingScheme
dcterms:hasVersion
<http://dublincore.org/usage/terms/history/#VocabularyEncodingScheme-001>
;
dcterms:issued "2008-01-14"^^<http://www.w3.org/2001/XMLSchema#date> ;
a rdfs:Class ;
rdfs:comment "An enumerated set of resources."@en ;
rdfs:isDefinedBy <http://purl.org/dc/dcam/> ;
rdfs:label "Vocabulary Encoding Scheme"@en ;
rdfs:seeAlso
<http://dublincore.org/documents/2007/06/04/abstract-model/> .
dcam:memberOf
dcterms:hasVersion
<http://dublincore.org/usage/terms/history/#memberOf-002> ;
dcterms:issued "2008-01-14"^^<http://www.w3.org/2001/XMLSchema#date> ;
dcterms:modified
"2010-10-11"^^<http://www.w3.org/2001/XMLSchema#date> ;
a rdf:Property ;
rdfs:comment "A relationship between a resource and a vocabulary
encoding scheme which indicates that the resource is a member of a
set."@en ;
rdfs:isDefinedBy <http://purl.org/dc/dcam/> ;
rdfs:label "Member Of"@en ;
rdfs:range dcam:VocabularyEncodingScheme ;
rdfs:seeAlso
<http://dublincore.org/documents/2007/06/04/abstract-model/> .
$ curl -v -T test.ttl -H Content-type:text/turtle
http://localhost:8890/sparql-graph-crud?graph-uri=http%3A%2F%2Fexample.com%2F
* About to connect() to localhost port 8890 (#0)
* Trying ::1...
* Connection refused
* Trying 127.0.0.1...
* connected
* Connected to localhost (127.0.0.1) port 8890 (#0)
> PUT /sparql-graph-crud?graph-uri=http%3A%2F%2Fexample.com
<http://2Fexample.com>%2F HTTP/1.1
> User-Agent: curl/7.24.0 (x86_64-apple-darwin12.0) libcurl/7.24.0
OpenSSL/0.9.8r zlib/1.2.5
> Host: localhost:8890
> Accept: */*
> Content-type:text/turtle
> Content-Length: 1636
> Expect: 100-continue
>
< HTTP/1.1 100 Continue
* We are completely uploaded and fine
< HTTP/1.1 201 Created
< Server: Virtuoso/06.01.3127 (Darwin) x86_64-apple-darwin12.2.0
< Connection: Keep-Alive
< Content-Type: text/html; charset=UTF-8
< Date: Wed, 23 Jan 2013 00:05:07 GMT
< Accept-Ranges: bytes
< Content-Length: 0
<
* Connection #0 to host localhost left intact
* Closing connection #0
$ /usr/local/vos/bin/isql 1111
Connected to OpenLink Virtuoso
Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL> sparql select * from <http://example.com/> where {?s ?p ?o};
s p
o
VARCHAR VARCHAR
LONG VARCHAR
_______________________________________________________________________________
http://purl.org/dc/dcam/ http://purl.org/dc/terms/modified
2012-06-14
http://purl.org/dc/dcam/ http://purl.org/dc/terms/publisher
http://purl.org/dc/aboutdcmi#DCMI
http://purl.org/dc/dcam/ http://purl.org/dc/terms/title
Metadata terms related to the
DCMI Abstract Model
http://purl.org/dc/dcam/VocabularyEncodingScheme
http://www.w3.org/1999/02/22-rdf-syntax-ns#type
http://www.w3.org/2000/01/rdf-schema#Class
http://purl.org/dc/dcam/VocabularyEncodingScheme
http://www.w3.org/2000/01/rdf-schema#label
Vocabulary Encoding Scheme
http://purl.org/dc/dcam/VocabularyEncodingScheme
http://www.w3.org/2000/01/rdf-schema#isDefinedBy http://purl.org/dc/dcam/
http://purl.org/dc/dcam/VocabularyEncodingScheme
http://www.w3.org/2000/01/rdf-schema#comment
An enumerated set of resources.
http://purl.org/dc/dcam/VocabularyEncodingScheme
http://www.w3.org/2000/01/rdf-schema#seeAlso
http://dublincore.org/documents/2007/06/04/abstract-model/
http://purl.org/dc/dcam/VocabularyEncodingScheme
http://purl.org/dc/terms/hasVersion
http://dublincore.org/usage/terms/history/#VocabularyEncodingScheme-001
http://purl.org/dc/dcam/VocabularyEncodingScheme
http://purl.org/dc/terms/issued
2008-01-14
http://purl.org/dc/dcam/memberOf
http://www.w3.org/1999/02/22-rdf-syntax-ns#type
http://www.w3.org/1999/02/22-rdf-syntax-ns#Property
http://purl.org/dc/dcam/memberOf http://purl.org/dc/terms/modified
2010-10-11
http://purl.org/dc/dcam/memberOf
http://www.w3.org/2000/01/rdf-schema#label
Member Of
http://purl.org/dc/dcam/memberOf
http://www.w3.org/2000/01/rdf-schema#range
http://purl.org/dc/dcam/VocabularyEncodingScheme
http://purl.org/dc/dcam/memberOf
http://www.w3.org/2000/01/rdf-schema#isDefinedBy http://purl.org/dc/dcam/
http://purl.org/dc/dcam/memberOf
http://www.w3.org/2000/01/rdf-schema#comment
A relationship between a resource and a vocabulary encoding
scheme which indicates that the resource is a member of a set.
http://purl.org/dc/dcam/memberOf
http://www.w3.org/2000/01/rdf-schema#seeAlso
http://dublincore.org/documents/2007/06/04/abstract-model/
http://purl.org/dc/dcam/memberOf http://purl.org/dc/terms/hasVersion
http://dublincore.org/usage/terms/history/#memberOf-002
http://purl.org/dc/dcam/memberOf http://purl.org/dc/terms/issued
2008-01-14
19 Rows. -- 1 msec.
SQL>
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
On 22 Jan 2013, at 22:35, Alexey Zakhlestin <indey...@gmail.com
<mailto:indey...@gmail.com>> wrote:
On 23.01.2013, at 1:14, Alexey Zakhlestin <indey...@gmail.com
<mailto:indey...@gmail.com>> wrote:
On 22.01.2013, at 23:09, Alexey Zakhlestin <indey...@gmail.com
<mailto:indey...@gmail.com>> wrote:
On 22.01.2013, at 21:57, Hugh Williams <hwilli...@openlinksw.com
<mailto:hwilli...@openlinksw.com>> wrote:
Hi Alexey,
Can you provide the sample query and turtle file you are using
when trying to perform such an insert/load please ?
Sure.
Here's the gist with HTTP-session log:
https://gist.github.com/1ecd33852dd02e23313e
By browsing virtuoso's source I found, that there's another
endpoint: http://127.0.0.1:8890/sparql-graph-crud
Query still doesn't work against it
ok. I figured it out.
I had couple of errors in query. This one works:
http --verbose POST
'http://localhost:8890/sparql-graph-crud?graph-uri=http%3A%2F%2Fexample.com%2F'
<http://localhost:8890/sparql-graph-crud?graph-uri=http%3A%2F%2Fexample.com%2F%27>
@app/rdf-schemas/cache/dublincore.org/2012/06/14/dcam.ttl
<http://dublincore.org/2012/06/14/dcam.ttl> Content-type:text/turtle
Accept:text/html
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET <http://ASP.NET>, C#
2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
