[Virtuoso-users] An (experimental) support for big SPARQL INSERT DATA and SPARQL DELETE DATA statements

2009-11-28 Thread Ivan Mikhailov
Hello, There were requests for support of really long SPARQL INSERT DATA statements but there was no good way of making that. Before. The attached patch should be suitable for all recent Virtuoso 5.xx builds. With this patch SPARQL INSERT DATA can load, say, the content of links_bookmashup_en.nt

Re: [Virtuoso-users] virtuoso / isql / ubuntu [mini howto]

2009-11-28 Thread Nathan
ahh well deduced, and as you say all works (virtuoso isql is much better)! # /usr/local/virtuoso-opensource/bin/isql localhost: dba dba Connected to OpenLink Virtuoso Driver: 06.00.3124 OpenLink Virtuoso ODBC Driver consider it symlink'd; thanks hugh :) Hugh Williams wrote: > Hi Nathan, >

Re: [Virtuoso-users] virtuoso / isql / ubuntu [mini howto]

2009-11-28 Thread Hugh Williams
Hi Nathan, So you are using the isql program bundled with unixODBC, which is not what should be used as Virtuoso has its own :-) The Virtuoso isql command line program is installed in the "bin" directory of your Virtuoso installation: $ /usr/local/virtuoso-opensource/bin/isql -? OpenLink Inter

Re: [Virtuoso-users] virtuoso / isql / ubuntu [mini howto]

2009-11-28 Thread Nathan
Olivier Berger wrote: > Le samedi 28 novembre 2009 à 15:50 +, Nathan a écrit : >> For anybody who can't connect to virtuoso via isql on ubuntu (ie getting >> the following error) >> >> # isql localhost: dba pass >> [ISQL]ERROR: Could not SQLConnect >> > > Isn't it that localhost is an IPV6

Re: [Virtuoso-users] virtuoso / isql / ubuntu [mini howto]

2009-11-28 Thread Olivier Berger
Le samedi 28 novembre 2009 à 15:50 +, Nathan a écrit : > For anybody who can't connect to virtuoso via isql on ubuntu (ie getting > the following error) > > # isql localhost: dba pass > [ISQL]ERROR: Could not SQLConnect > Isn't it that localhost is an IPV6 address and it will work with I

Re: [Virtuoso-users] virtuoso / isql / ubuntu [mini howto]

2009-11-28 Thread Nathan
Hi Hugh, In all honesty I wouldn't waste your time; can't remember if iodbc was already installed or not (have a feeling it wasn't though, hence why i had it listed under my history); primarily though the focus of the howto was because you can't connect via localhost: or on ubuntu; thus y

Re: [Virtuoso-users] virtuoso / isql / ubuntu [mini howto]

2009-11-28 Thread Nathan
Just did a quick dependency check. isql is provided by unixodbc (not iodbc) on ubuntu # aptitude show unixodbc Package: unixodbc Depends: libc6 (>= 2.7-1), libltdl3 (>= 1.5.2-2), libreadline5 (>= 5.2), odbcinst1debian1 (>= 2.2.11-3) iodbc itself is not installed by default so needs an apt-get r

Re: [Virtuoso-users] virtuoso / isql / ubuntu [mini howto]

2009-11-28 Thread Hugh Williams
Hi Nathan, Hmmm, that is confusing to me as isql should not have an iODBC dependancy, as is the case on my Mac OS X and Debian Linux boxes: $ ldd isql linux-gate.so.1 => (0xb7eef000) libssl.so.0.9.8 => /usr/lib/i686/cmov/libssl.so.0.9.8 (0xb7e96000) libcrypto.so.0.9.8 =

Re: [Virtuoso-users] virtuoso / isql / ubuntu [mini howto]

2009-11-28 Thread Eddy Vanderlinden
Thanks Nathan, I struggled with this earlier and did not get out. Best regards Eddy - Original Message - From: "Nathan" To: "virtuoso Users List" Sent: Saturday, November 28, 2009 4:50 PM Subject: [Virtuoso-users] virtuoso / isql / ubuntu [mini howto] For anybody who can't connec

[Virtuoso-users] virtuoso / isql / ubuntu [mini howto]

2009-11-28 Thread Nathan
For anybody who can't connect to virtuoso via isql on ubuntu (ie getting the following error) # isql localhost: dba pass [ISQL]ERROR: Could not SQLConnect here's how to sort it.. install iodbc: # apt-get install iodbc create a dsn connection: # nano /etc/odbc.ini enter the following (wh

Re: [Virtuoso-users] VSP and Sparql

2009-11-28 Thread Ivan Mikhailov
Hello Lourens, > FOR (sparql select ?labl (lang(?labl)) where {$:subject > skos:prefLabel ?labl}) DO { >^^ HOW DO I GET THE > lang(?labl) VALUE? The syntax is FOR (sparql select ?labl (lang(?labl)) as ?lang_of_labl where ... ) DO and

Re: [Virtuoso-users] VSP and Sparql

2009-11-28 Thread Aldo Bucchi
Hi Lourens, In general, when you run any sort of function ( aggregate, built-in, etc ) in the projection part of the query you should also define an alias for the variable using AS {varName} select count(?s) as ?count_s ... select ?s lang(?label) as ?lang ?p ?o for example: select ?s ?label

Re: [Virtuoso-users] Correct way to shut down the Virtuoso- Server

2009-11-28 Thread Rumi Tsekova
Hi Sashikiran, Additionally re. uploading in the RDF_Quad table: 1. You can upload files to the ODS RDF Sink folder - see details here: http://ods.openlinksw.com/dataspace/dav/wiki/ODS/ODSRDFSinkFolder - the Graph URI is http://cname/DAV/home/username/rdf_sink 2. Another way is using WebD

[Virtuoso-users] VSP and Sparql

2009-11-28 Thread Lourens van der Meij
I am trying to get the hang of VSP and am currently a bit stuck on getting info from sparql queries in FOR constructs. Named variables are ok, but how do I get select (lang(?label)) count(..) ... values? A part of my VSP code(I got '$:subject' from a surrounding "FOR (sparql select .."): http:

Re: [Virtuoso-users] Correct way to shut down the Virtuoso- Server

2009-11-28 Thread Hugh Williams
Hi Sashhikiran, Generally kill'ing Unix processes especially with -9 is only performed as a last resort and the process with have no chance to perform any cleanup. For virtuoso in particular this would result in all transactions since the last checkpoint not being comitted to the database and r

Re: [Virtuoso-users] Correct way to shut down the Virtuoso- Server

2009-11-28 Thread Rameswara Sashi Kiran Challa
Dear Hugh, Is Killing that particular virtuoso process a right thing to do ? I am a newbie so whats wrong in doing that. Thanks On Fri, Nov 27, 2009 at 8:15 PM, Hugh Williams wrote: > Hi Sashikiran, > > You can shutdown the Virtuoso by connecting to it with the isql command > line interactive sq

Re: [Virtuoso-users] Correct way to shut down the Virtuoso- Server

2009-11-28 Thread Hugh Williams
Hi Sashikiran, You can shutdown the Virtuoso by connecting to it with the isql command line interactive sql tool and running the shutdown command, as detailed at: http://docs.openlinksw.com/virtuoso/isql.html#invokingisql The following query can be run to obtain a list of available Grap