That worked! I got:
callret-0 Insert into <http://BookStore.com>, 3 (or less) triples -- done Thanks, -sherman On Thu, Aug 4, 2011 at 9:56 AM, Hugh Williams <[email protected]>wrote: > Hi Sherman, > > Try executing the following from isql as the "dba" user: > > grant execute on SPARQL_INSERT_DICT_CONTENT to "SPARQL" > grant execute on SPARQL_INSERT_DICT_CONTENT to SPARQL_UPDATE > > Best Regards > Hugh Williams > Professional Services > OpenLink Software > Web: http://www.openlinksw.com > Support: http://support.openlinksw.com > Forums: http://boards.openlinksw.com/support > Twitter: http://twitter.com/OpenLink > > On 4 Aug 2011, at 14:16, Sherman Monroe wrote: > > Hi Ivan, > > I tried removing the SPARQL, also, I gave dba all roles and all grants. I > now get this error: > > Virtuoso 42000 Error SR186: No permission to execute procedure > DB.DBA.SPARQL_INSERT_DICT_CONTENT with user ID 106, group ID 106 > > SPARQL query: > > #output-format:text/html > INSERT IN GRAPH <http://BookStore.com> > { <http://www.dajobe.org/foaf.rdf#i> <http://purl.org/dc/elements/1.1/date> > <1999-04-01T00:00:00> . > <http://www.w3.org/People/Berners-Lee/card#i> > <http://purl.org/dc/elements/1.1/date> <1998-05-03T00:00:00> . > <http://www.w3.org/People/Connolly/#me> > <http://purl.org/dc/elements/1.1/date> <2001-02-08T00:00:00> } > > > -sherman > > On Sat, Jul 30, 2011 at 10:57 PM, Ivan Mikhailov < > [email protected]> wrote: > >> Hello Sherman, >> >> > Virtuoso 37000 Error SP030: SPARQL compiler, line 3: syntax error at >> 'SPARQL' before 'INSERT' >> > >> > SPARQL query: >> > >> > #output-format:text/html >> > define sql:signal-void-variables 1 SPARQL INSERT IN GRAPH < >> http://BookStore.com> >> > { <http://www.dajobe.org/foaf.rdf#i> < >> http://purl.org/dc/elements/1.1/date> <1999-04-01T00:00:00> . >> > <http://www.w3.org/People/Berners-Lee/card#i> < >> http://purl.org/dc/elements/1.1/date> <1998-05-03T00:00:00> . >> > <http://www.w3.org/People/Connolly/#me> < >> http://purl.org/dc/elements/1.1/date> <2001-02-08T00:00:00> }; >> >> When used in stored procedure or called via ISQL, it should be >> SPARQL define sql:signal-void-variables 1 INSERT IN GRAPH ... >> When called via SPARQL web service endpoint, the SPARQL keyword is not >> needed at all. >> >> "SPARQL" is a Virtuoso SQL keyword that indicates where SPARQL-to-SQL >> front-end should start to read the text (and to replace the source >> SPARQL text with compiled SQL fragment). So it should be placed before >> DEFINE. Web service endpoint does not need this keyword because it does >> not expect anything other than SPARQL and it don't have to distinguish >> between SPARQL and surrounding SQL. >> >> Best Regards, >> >> Ivan Mikhailov >> OpenLink Software >> http://virtuoso.openlinksw.com >> >> >> > > > -- > > Thanks, > -sherman > > I pray that you may prosper in all things and be healthy, even as your soul > prospers > (3 John 1:2) > ------------------------------------------------------------------------------ > BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA > The must-attend event for mobile developers. Connect with experts. > Get tools for creating Super Apps. See the latest technologies. > Sessions, hands-on labs, demos & much more. Register early & save! > > http://p.sf.net/sfu/rim-blackberry-1_______________________________________________ > > Virtuoso-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/virtuoso-devel > > > -- Thanks, -sherman I pray that you may prosper in all things and be healthy, even as your soul prospers (3 John 1:2)
