[Virtuoso-users] Can the PL source code of the HTTP SPARQL client be modified?

2017-11-09 Thread Beppe Mazzola
Dear community, I want to see how the built-in Virtuoso Open Source HTTP SPARQL client (the one that responds when you type http:://servername:8890/sparql) is implemented and evaluate the possibilitly to change it. I haven't found any documentation about it but I discovered anyway that it's implem

Re: [Virtuoso-users] triples not reached by the index?

2017-06-23 Thread Beppe Mazzola
827/ > Facebook -- http://www.facebook.com/OpenLinkSoftware > Universal Data Access, Integration, and Management Technology Providers > > > > On 22 May 2017, at 14:52, Beppe Mazzola wrote: > > Hi Hughs > > It seems the problem is not related to the RDF views tied to

[Virtuoso-users] SPARQL: Internal error: The length of generated SQL text has exceeded 10000 lines of code

2017-06-22 Thread Beppe Mazzola
rage" / "create IRI class" etc. statements > ever used to configure the storage. If they're not preserved, I need the > exact output of sparql statement > > define input:storage "" define output:format "TTL" > construct { ?s ?p ?o } from virtrdf: w

[Virtuoso-users] how to pass as parameter the virtual graph IRI to a SPARQL statement ?

2017-06-19 Thread Beppe Mazzola
Hi to all I am trying to develop a SPARQL statement in a stored procedure related to a virtual graph (result of a R2RML mapping) having its IRI not hard coded, but contained in a variable. I have tried for example the following syntax, but the query does not return any triple. declare graphName

Re: [Virtuoso-users] triples not reached by the index?

2017-05-22 Thread Beppe Mazzola
something in the Sqlworkbench/j or (it seems to me more likely) in the JDBC driver that causes the issue. Cheers Beppe 2017-05-16 10:27 GMT+01:00 Beppe Mazzola : > Hi Hugh > > I have noticed something strange related to the PK index of the table > provided to you. > > After having r

Re: [Virtuoso-users] triples not reached by the index?

2017-05-16 Thread Beppe Mazzola
the rows with ID=0 one of them is deleted, and the remaining one is visible only with select not using the PK index. This might have a relation with the original RDF view issue I have used the Conductor Interactive SQL. Cheers Beppe 2017-05-16 9:25 GMT+01:00 Beppe Mazzola : > Hi H

Re: [Virtuoso-users] triples not reached by the index?

2017-05-16 Thread Beppe Mazzola
blogs/ > LinkedIn -- http://www.linkedin.com/company/openlink-software/ > Twitter -- http://twitter.com/OpenLink > Google+ -- http://plus.google.com/100570109519069333827/ > Facebook -- http://www.facebook.com/OpenLinkSoftware > Universal Data Access, Integration, and Management T

[Virtuoso-users] triples not reached by the index?

2017-05-13 Thread Beppe Mazzola
Hi to everybody I have generated with Virtuoso Open Source a virtual graph with the content of many RDB tables.obtained with an R2RML mapping. If I execute the following query I do not get any result. select * from where {

[Virtuoso-users] SPARQL run-time errors querying a virtual graph

2017-05-03 Thread Beppe Mazzola
Hi to everybody I am trying to query the content of a virtual graph, obtained in Virtuoso Open Source via the R2RML mapping. Executing (relatively) simple SPARQL statements I get run-time errors and I do not understand why. *Example 1) * prefix pest:

[Virtuoso-users] Unable to setup UTF-8 encoding in the relational DB

2017-03-29 Thread Beppe Mazzola
d the Virtuoso driver virtjdbc4.jar I have tried to prepare the statement before executing it, but nothing changes. Does anyone see something wrong or missing? Thanks! Cheers Beppe 2017-03-23 17:05 GMT+00:00 Beppe Mazzola : > Hi Sergey > > Thank you again for your feed

Re: [Virtuoso-users] Sposta in Posta in arrivo Altro 1 di 3.655 Espandi tutto Stampa tutto In una nuova finestra Unable to setup UTF-8 encoding in the relational DB

2017-03-29 Thread Beppe Mazzola
where. Thanks Beppe 2017-03-28 10:35 GMT+01:00 Sergey Malinin : > On 03/28/2017 07:32 AM, Beppe Mazzola wrote: > > Hi > > I want to use the JDBC driver in order to load data into my Virtuoso > relational DB. > As first thing I would like to see the driver working fine ins

[Virtuoso-users] Sposta in Posta in arrivo Altro 1 di 3.655 Espandi tutto Stampa tutto In una nuova finestra Unable to setup UTF-8 encoding in the relational DB

2017-03-27 Thread Beppe Mazzola
oso.ini ;SQL_UTF8_EXECS = 1 and used the Virtuoso driver virtjdbc4.jar I have tried to prepare the statement before executing it, but nothing changes. Does anyone see something wrong or missing? Thanks! Cheers Beppe 2017-03-23 17:05 GMT+00:00 Beppe Mazzola : > Hi Sergey > > Thank you a

Re: [Virtuoso-users] Unable to setup UTF-8 encoding in the relational DB

2017-03-23 Thread Beppe Mazzola
you suggested, restoring the NVARCHAR columns in the RDB. Thanks again Cheers Beppe 2017-03-23 15:07 GMT+00:00 Sergey Malinin : > On 03/23/2017 12:45 AM, Beppe Mazzola wrote: > >> Thanks Sergey >> >> Your suggestion inspired me to do some more trials. >>

Re: [Virtuoso-users] Unable to setup UTF-8 encoding in the relational DB

2017-03-22 Thread Beppe Mazzola
0 GMT+00:00 Sergey Malinin : > On 03/21/2017 04:42 AM, Beppe Mazzola wrote: > >> Related to the problem I have about storing non-Latin character in >> Virtuoso RDB, I see now that I haven't provided all the info related to it. >> >> So it was not evident that the H

Re: [Virtuoso-users] Unable to setup UTF-8 encoding in the relational DB

2017-03-20 Thread Beppe Mazzola
ea, hint are very welcome! Thanks Cheers Beppe 2017-02-27 10:21 GMT+00:00 Beppe Mazzola : > Hi Hugh > > This should reproduce the problem. In my Virtuoso installation the > Bulgarian text inserted in the test table is different to the one displayed > as a result of the select. >

Re: [Virtuoso-users] Unable to delete a graph content / Unable to iterate on graph triples - Same problem?!

2017-03-08 Thread Beppe Mazzola
og -- http://www.openlinksw.com/blogs/ > LinkedIn -- http://www.linkedin.com/company/openlink-software/ > Twitter -- http://twitter.com/OpenLink > Google+ -- http://plus.google.com/100570109519069333827/ > Facebook -- http://www.facebook.com/OpenLinkSoftware > Universal Data Access, I

[Virtuoso-users] Unable to delete a graph content / Unable to iterate on graph triples - Same problem?!

2017-03-06 Thread Beppe Mazzola
Hi to all Recently I have sent two e-mails to this forum about two different problems: - *Unable to iterate over a SPARQL query referring to a graph.* In a stored procedure the iterations over a SPARQL statement result set are not executed. See https://sourceforge.net/p/virtuoso/mail

Re: [Virtuoso-users] Unable to setup UTF-8 encoding in the relational DB

2017-03-01 Thread Beppe Mazzola
, Integration, and Management Technology Providers > > > > On 22 Feb 2017, at 14:20, Beppe Mazzola wrote: > > Hi to all > > In order to have Virtuoso relational DB able to correctly store the text > with the UTF-8 encoding I have performed the following operation

[Virtuoso-users] Cannot validate R2RML

2017-03-01 Thread Beppe Mazzola
Hi to all again I have the following problem. When I try to validate my R2RML script in my Virtuoso installation I get the following error. SQL> DB.DBA.OVL_VALIDATE ('http://temp/testR2RML', ' http://www.w3.org/ns/r2rml#OVL-nosuch'); SUBJ SEVERITY MESSAGE VARCHAR VARCHAR VARCHAR _

[Virtuoso-users] How do I iterate over a SPARQL query referring to a graph?

2017-02-24 Thread Beppe Mazzola
Hi to everybody I am developing a Virtuoso stored procedure. I want to perform a loop over the result of a SPARQL query. The problem comes when the query contains a reference to a graph. In all my attempts I get no error but an empty result set as well. I tried the following create procedure R2RM

[Virtuoso-users] Unable to setup UTF-8 encoding in the relational DB

2017-02-22 Thread Beppe Mazzola
Hi to all In order to have Virtuoso relational DB able to correctly store the text with the UTF-8 encoding I have performed the following operations. - all the columns with text declared as NVARCHAR(n) - in virtuoso.ini file - SQL_UTF8_EXECS = 1 - Charset

Re: [Virtuoso-users] Unable to delete a graph content

2017-02-08 Thread Beppe Mazzola
thing in the graph content or in the way it is generated that prevents it to be dropped / emptied? Thanks Cheers Beppe 2017-02-07 16:07 GMT+00:00 Ted Thibodeau Jr : > Hi, Beppe -- > > Bringing this back to the list (as you suggested I might), as > others may notice something I have

Re: [Virtuoso-users] Unable to delete a graph content

2017-02-07 Thread Beppe Mazzola
the e-mail. But is the IRI treated in Virtuoso just like a unique string? I mean, is it needed it to resolve to an HTTP correct response? Thanks Ted a lot for your help! Cheers Beppe 2017-02-07 16:07 GMT+00:00 Ted Thibodeau Jr : > Hi, Beppe -- > > Bringing this back to the list (as you sugg

[Virtuoso-users] Unable to delete a graph content

2017-02-06 Thread Beppe Mazzola
Hi to everybody I am new to Virtuoso. I am using Virtuoso Open Source 7 in both Windows and Linux I am trying to delete the content of a graph with 75 triples. I have tried using the following statements both in ISQL and in the Orchestrator. The whole graph removal is tried as well. SPARQL CLEAR