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

2009-06-15 Thread Kurt J
>> after closing the odbc connection the graph is empty!  any idea what gives? > > Just in case: Perhaps the commands were run in a transaction and you > forgot to do `connection.commit()`? hehe. you're right. my mistake. i needed to call connect.commit() sorry, odbc nb :-)

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

2009-06-15 Thread Leo Soto M.
On Mon, Jun 15, 2009 at 12:20 PM, Kurt J wrote: > after closing the odbc connection the graph is empty!  any idea what gives? Just in case: Perhaps the commands were run in a transaction and you forgot to do `connection.commit()`? -- Leo Soto M. http://blog.leosoto.com

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

2009-06-15 Thread Kurt J
Ok. finally using DB.DBA.RDF_LOAD_RDFXML_MT instead of DB.DBA.RDF_LOAD_RDFXML works as expected. not sure i grok the difference between the two. but for me (python 2.5, pyodbc, os x, vos 5.11) only DB.DBA.RDF_LOAD_RDFXML _MT seemed to work properly from the python odbc connection hope this may

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

2009-06-15 Thread Kurt J
> In [61]: connect.execute('''DB.DBA.RDF_LOAD_RDFXML (file_to_string > ('/test-virtuoso/cmn2.rdf'), '', 'http://mygraph.com') ; ''') finally, it seems the problem here is the ';' omitting this it takes the command but there's another problem now: In [4]: connect.execute('''DB.DBA.RDF_LOAD_RDFXML

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

2009-06-15 Thread Kurt J
great thnx Hugh. Still some problems using DB.DBA.RDF_LOAD_RDFXML seems to work fine in ISQL but i get a syntax error in python odbc connection: In [61]: connect.execute('''DB.DBA.RDF_LOAD_RDFXML (file_to_string ('/test-virtuoso/cmn2.rdf'), '', 'http://mygraph.com') ; ''') -

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

2009-06-15 Thread Hugh Williams
Hi Kurt, I shall have to check with development if the "file://" prefix is supported as I get a similar problem using isql : SQL> sparql load "file://vc-db-1.rdf" into ; *** Error 39000: [Virtuoso Driver][Virtuoso Server]FA005: Can't open file '/usr/local/virtuoso-opens

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

2009-06-15 Thread Kurt J
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 wrote: > Hi Hugh, > > thanks but this still does not seem to work.  from the virtuoso.ini file: > > DirsAllowed          

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

2009-06-15 Thread Kurt J
Hi Hugh, thanks but this still does not seem to work. from the virtuoso.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 me

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

2009-06-12 Thread Hugh Williams
Hi Kurt, You indicate the file is in your ./vsp folder, but is the Virtuoso Server Allowed Access to this location as indicated in the the "DirsAllows" parameter of the configuration file (virtuoso.ini) ? By default the config file contains: DirsAllowed = ., /usr/local/virtuoso-opensour

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

2009-06-12 Thread Kurt J
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 into ''') ---