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
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,
>
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
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
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
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
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
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 =
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
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
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
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
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
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:
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
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
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
17 matches
Mail list logo