Hi Erich, Good to hear, thus I presume the query now runs successful for you ?
Also, what is the version of Virtuoso in use which can be obtained by running
the command:
virtuoso-t -?
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 23 Jan 2013, at 02:14, Erich Bremer <[email protected]> wrote:
> 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%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 <[email protected]> wrote:
>>
>>>
>>> On 23.01.2013, at 1:14, Alexey Zakhlestin <[email protected]> wrote:
>>>
>>>>
>>>> On 22.01.2013, at 23:09, Alexey Zakhlestin <[email protected]> wrote:
>>>>
>>>>>
>>>>> On 22.01.2013, at 21:57, Hugh Williams <[email protected]> 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'
>>> @app/rdf-schemas/cache/dublincore.org/2012/06/14/dcam.ttl
>>> Content-type:text/turtle Accept:text/html
>>> ------------------------------------------------------------------------------
>>> 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
>>> [email protected]
>>> 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
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ 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 [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
