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
