Re: [Virtuoso-users] inserting a local rdf file into the store

Hugh Williams Mon, 15 Jun 2009 13:02:58 +0000

Hi Kurt,

I shall have to check with development if the "file://" prefix issupported as I get a similar problem using isql :


SQL> sparql load "file://vc-db-1.rdf" into <http://mygraph.com>;

*** Error 39000: [Virtuoso Driver][Virtuoso Server]FA005: Can't openfile '/usr/local/virtuoso-opensource/var/lib/virtuoso/vsp/D5=1bd406a9e59cb59be0cb0262a45d56f6&graphMD5=3e67775edad527462fe95c1f287d9dab', error 2

at line 1 of Top-Level:
sparql load "file://vc-db-1.rdf" into <http://mygraph.com>

In the meantime can you not use one of the other load methods likeRDF_XML_LOAD, which does work for me:

SQL> DB.DBA.RDF_LOAD_RDFXML (file_to_string ('/usr/local/virtuoso-opensource/var/lib/virtuoso/db/vc-db-1.rdf'), '', 'http://mygraph.com');


Done. -- 3 msec.

SQL> sparql select distinct ?s ?p ?o from <http://mygraph.com>where {?s ?p ?o};spoVARCHARVARCHARVARCHAR_______________________________________________________________________________

http://somewhere/JohnSmith/http://www.w3.org/2001/vcard-rdf/3.0#FN John Smithhttp://somewhere/JohnSmith/http://www.w3.org/2001/vcard-rdf/3.0#N nodeID://1000010004http://somewhere/RebeccaSmith/http://www.w3.org/2001/vcard-rdf/3.0#FN Becky Smithhttp://somewhere/RebeccaSmith/http://www.w3.org/2001/vcard-rdf/3.0#N nodeID://1000010005http://somewhere/SarahJones/http://www.w3.org/2001/vcard-rdf/3.0#FN Sarah Joneshttp://somewhere/SarahJones/http://www.w3.org/2001/vcard-rdf/3.0#N nodeID://1000010006http://somewhere/MattJones/http://www.w3.org/2001/vcard-rdf/3.0#FN Matt Joneshttp://somewhere/MattJones/http://www.w3.org/2001/vcard-rdf/3.0#N nodeID://1000010007nodeID://1000010004http://www.w3.org/2001/vcard-rdf/3.0#Family SmithnodeID://1000010004http://www.w3.org/2001/vcard-rdf/3.0#Given JohnnodeID://1000010005http://www.w3.org/2001/vcard-rdf/3.0#Family SmithnodeID://1000010005http://www.w3.org/2001/vcard-rdf/3.0#Given RebeccanodeID://1000010006http://www.w3.org/2001/vcard-rdf/3.0#Family JonesnodeID://1000010006http://www.w3.org/2001/vcard-rdf/3.0#Given SarahnodeID://1000010007http://www.w3.org/2001/vcard-rdf/3.0#Family JonesnodeID://1000010007http://www.w3.org/2001/vcard-rdf/3.0#Given Matthew


16 Rows. -- 35 msec.

Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support



On 15 Jun 2009, at 11:04, Kurt J wrote:

in case there is another option in my virtuoso.ini file that might be
wrong, it is here:

http://pastebin.com/m7494e063

cheers,
kurt j

On Mon, Jun 15, 2009 at 10:58 AM, Kurt J<kur...@gmail.com> wrote:
Hi Hugh,
thanks but this still does not seem to work. from thevirtuoso.ini file:
DirsAllowed = ., /usr/local/virtuoso-opensource/share/virtuoso/vad,
/test-virtuoso

i've but the file in '.' and '/test-virtuoso' and '/usr/local/...
/vad' to no avail.

i get the same error message:

In [42]: connect.execute('''sparql load
<file://usr/local/virtuoso-opensource/share/virtuoso/vad/cmn.rdf>into
<http://test.cmn.graph>''')
---------------------------------------------------------------------------Error Traceback (most recentcall last)
/Users/kurtjx/Documents/workspace/myspace-serv/src/<ipython console>
in <module>()

Error: ('39000', "[39000] [OpenLink][Virtuoso iODBC Driver][Virtuoso
Server]FA005: Can't open file
'/test-virtuoso/vsp/D5=17eaf0b98fe28b8448405cdb159b7b58&graphMD5=ec2d5ae1a16231d222dfb7ecbdfd60cf',
error 2 (-1) (SQLExecDirectW)")

thanks for your help.

-kurt
On Sat, Jun 13, 2009 at 12:49 AM, HughWilliams<hwilli...@openlinksw.com> wrote:
Hi Kurt,
You indicate the file is in your ./vsp folder, but is theVirtuoso Server
Allowed Access to this location as indicated in the the "DirsAllows"
parameter of the configuration file (virtuoso.ini) ? By defaultthe config
file contains:
DirsAllowed = ., /usr/local/virtuoso-opensource/share/virtuoso/vad,
/usr/local/virtuoso-opensource/var/lib/virtuoso/db
So I would suggest placing the file in the "db" folder assumingthis is in
your DirsAllowed param ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support


On 12 Jun 2009, at 18:20, Kurt J wrote:

Hi All,
I want to insert a local rdf into the store thru an odbc connection.
Is this doable?
If i put the file in the ./vsp dir, i get this:
In [29]: con =
pyodbc.connect('DSN=SysVirt;UID=dba;PWD=dba;HOST=localhost:1112')
In [30]: con.execute('''sparql load <file://cmn2.rdf> into
<http://test.cmn.graph>''')
---------------------------------------------------------------------------Error Traceback (most recentcall last)
/Users/kurtjx/Documents/workspace/myspace-serv/src/<ipython console>
in <module>()
Error: ('39000', "[39000] [OpenLink][Virtuoso iODBC Driver][Virtuoso
Server]FA005: Can't open file
'/test-virtuoso/vsp/D5=17eaf0b98fe28b8448405cdb159b7b58&graphMD5=fa0c30ab328817713407d402b927a311',
error 2 (-1) (SQLExecDirectW)")

also note that i first tried:
con.execute('''sparql load <cmn2.rdf> into <http://test.cmn.graph>''')
(no 'file://') and this crashed virtuoso 5.11 w/ a segfault.just fyi.
thanks,
Kurt J
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] inserting a local rdf file into the store

Reply via email to