Hi Jakub,
What is the Virtuoso version you are using (virtuoso-t -?) ?
Your call to DB.DBA.RDF_AUDIT_METADATA should be as follows ie you are missing
the single quote around '*' :
SQL> DB.DBA.RDF_AUDIT_METADATA(1, '*');
STAT MSG
VARCHAR VARCHAR
_______________________________________________________________________________
00000 Reloading built-in metadata, this might fix some errors without
accurate reporting that they did exist
00000 Built-in metadata were reloaded
00000 Metadata from system graph are cached in memory-resident JSOs
(JavaScript Objects)
3 Rows. -- 475 msec.
SQL>
When I run the basic.sql script against the latest git develop/7 branch I get a
different error which need to be looked into:
SQL> load basic.sql;
Done. -- 8 msec.
Done. -- 1 msec.
Done. -- 30 msec.
Done. -- 1 msec.
Done. -- 45 msec.
*** Error 42001: VD [Virtuoso Server]SR185: Undefined procedure
DB.DBA.R2RML_MAKE_QM_FROM_G.
at line 65 of load basic.sql:
exec ('sparql ' || DB.DBA.R2RML_MAKE_QM_FROM_G ('http://temp/product'))
s
p
o
VARCHAR
VARCHAR
VARCHAR
_______________________________________________________________________________
0 Rows. -- 0 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 30 Apr 2014, at 16:53, Jakub Káňa <jakubk...@gmail.com> wrote:
> Hello, I am trying to learn how to use R2RML but I don't get any data in
> return when I run basic.sql in iSQL.
> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtR2RML
>
> How can I fix it?
>
> OpenLink Interactive SQL (Virtuoso), version 0.9849b.
> Type HELP; for help and EXIT; to exit.
> SQL> LOAD basic.sql;
> Connected to OpenLink Virtuoso
> Driver: 07.10.3207 OpenLink Virtuoso ODBC Driver
>
> *** Error 42S01: [OpenLink][Virtuoso ODBC Driver][Virtuoso Server]SQ016:
> Table R
> 2RML.TEST.PRODUCT already exists
> in lines 2-5 of LOAD basic.sql:
> #line 2 "basic.sql"
> create table "R2RML"."TEST"."PRODUCT"(
> id integer primary key,
> name VARCHAR(100)
> )
>
> Done. -- 0 msec.
>
> Done. -- 0 msec.
>
> Done. -- 0 msec.
>
> Done. -- 0 msec.
> STATE MESSAGE
> VARCHAR VARCHAR
> _______________________________________________________________________________
>
> 00000 Previous definition of IRI class
> <r2rml:virt02-8513ca7e0ce41d2e38f0c750
> fd552139> has been dropped
> 00000 Previous definition of IRI class
> <r2rml:virt02-8513ca7e0ce41d2e38f0c750
> fd552139> has been dropped
> 00000 IRI class <r2rml:virt02-8513ca7e0ce41d2e38f0c750fd552139> has been
> defi
> ned (inherited from rdfdf:sql-integer-uri-nullable)
> 00000 Previous definition of IRI class
> <r2rml:virt02-daca9ceddea29d53dbbdb6bd
> 0f3dee68> has been dropped
> 00000 Previous definition of IRI class
> <r2rml:virt02-daca9ceddea29d53dbbdb6bd
> 0f3dee68> has been dropped
> 00000 Literal class <r2rml:virt02-daca9ceddea29d53dbbdb6bd0f3dee68> has
> been
> defined (inherited from rdfdf:sql-integer-literal-nullable)
> 00000 Previous definition of IRI class
> <r2rml:virt02-daca9ceddea29d53dbbdb6bd
> 0f3dee68> has been dropped
> 00000 Previous definition of IRI class
> <r2rml:virt02-daca9ceddea29d53dbbdb6bd
> 0f3dee68> has been dropped
> 00000 Literal class <r2rml:virt02-daca9ceddea29d53dbbdb6bd0f3dee68> has
> been
> defined (inherited from rdfdf:sql-integer-literal-nullable)
> 22023 The quad storage
> "http://www.openlinksw.com/schemas/virtrdf#DefaultQuad
> Storage" is edited by other client, started 2014-02-26 13:09:54
> 00000 Quad storage
> <http://www.openlinksw.com/schemas/virtrdf#DefaultQuadStor
> age> is flagged as being edited 2014-02-26 13:09:54
> 42000 Can not process data that are being edited by someone else.
> 00000 To force tests/bugfixing, pass 1 as first argument and either
> '2419338d
> df300bab102973217b871483' or '*' as second argument of the
> DB.DBA.RDF_AUDIT_META
> DATA() call
>
> 13 Rows. -- 63 msec.
> s
> p
> o
> LONG VARCHAR
> LONG VARCHAR
> LONG VARCHAR
> _______________________________________________________________________________
>
>
> 0 Rows. -- 0 msec.
> SQL> DB.DBA.RDF_AUDIT_METADAT(1,2419338ddf300bab102973217b871483);
>
> *** Error 37000: [OpenLink][Virtuoso ODBC Driver][Virtuoso Server]SQ074: Line
> 1:
> Aliases are not allowed here (missing comma between arguments of a function
> cal
> l?) at ')' before ';'
> at line 2 of Top-Level:
> DB.DBA.RDF_AUDIT_METADAT(1,2419338ddf300bab102973217b871483)
> SQL> DB.DBA.RDF_AUDIT_METADAT(1,*);
>
> *** Error 37000: [OpenLink][Virtuoso ODBC Driver][Virtuoso Server].....: A *
> is
> not allowed in a variable's place in an expression
> at line 3 of Top-Level:
> DB.DBA.RDF_AUDIT_METADAT(1,*)
> SQL>
>
> Jakub
> ------------------------------------------------------------------------------
> "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
> Instantly run your Selenium tests across 300+ browser/OS combos. Get
> unparalleled scalability from the best Selenium testing platform available.
> Simple to use. Nothing to install. Get started now for free."
> http://p.sf.net/sfu/SauceLabs_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos. Get
unparalleled scalability from the best Selenium testing platform available.
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
