Re: [Virtuoso-devel] problems using sparul

[Hugh W. <hwi...@op...>]

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 <imi...@op...> 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&reg; 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
> Vir...@li...
> https://lists.sourceforge.net/lists/listinfo/virtuoso-devel