[Virtuoso-users] Transitivity query - get all transitive parent classes of a given class

Hello everyone, I want to get all transitive parent classes of a given class. The data is already stored in a Virtuoso server with SPARQL 1.1 and the ontology contains 1 159 021 classes. The query that I executed is: query 1

[Virtuoso-users] sparql query which works in Virtuoso 6 but not in Virtuoso 7

Hello, I do not understand why two SPARQL queries work in Virtuoso 06.01.3127 but not in Virtuoso 07.20.3214. May you help me? These are the equivalent queries launched against a Dbpedia dataset. ### SELECT ?superclass {GRAPH

Re: [Virtuoso-users] sparql query which works in Virtuoso 6 but not in Virtuoso 7

> In the meantime you can use this work around. > > SELECT ?superclass {GRAPH <http://dbpedia.org> { > ?class rdfs:subClassOf [] . > [] rdfs:subClassOf ?superclass . > ?class rdfs:subClassOf* ?superclass. > FILTER (?class = <http://dbpedia.org/ontology/Actor>) > }}

[Virtuoso-users] how to disable transitivity in sparql queries

Hello I would like to retrieve explicitly stated triples for this simple query SELECT DISTINCT ?class { ?instance rdf:type ?class. FILTER (?instance = ) } but Virtuoso includes inferred triples as well in the results. Then, instead to get only

[Virtuoso-users] how to speed up rows insertion by sql commands

Hi, I would like to speed up a set of rows insertions using this sql command "INSERT INTO TEST.DBA.TEST (instance1, classname1, graphname) VALUES(iri_id_from_num(?),iri_id_from_num(?),iri_to_id(?))" The table structure is simple create table TEST.DBA.TEST ( "instance1" IRI_ID, "classname1"

Re: [Virtuoso-users] Load MySQL database into Virtuoso server

yes, it is possible in the community version. In Java, you can create tables and insert data by SQL queries using the JDBC drivers http://docs.openlinksw.com/virtuoso/virtuosodriverpackaging/ On Tue, Jan 17, 2017 at 11:31 AM, AA Saa wrote: > is there any way to do this with

[Virtuoso-users] encoded string insertion problem

Hello, I have a problem to insert data in the correct encoding with the virtjdbc-4.1.jar driver. When the java code tries to insert http://dbpedia.org/resource/Śleszyn the database stores http://dbpedia.org/resource/Zleszyn Java is managing correctly the encoding because the string is

Re: [Virtuoso-users] encoded string insertion problem

oftware/ > Twitter -- http://twitter.com/OpenLink > Google+ -- http://plus.google.com/100570109519069333827/ > Facebook -- http://www.facebook.com/OpenLinkSoftware > Universal Data Access, Integration, and Management Technology Providers > >> On 22 Aug 2016, at 13:15, Adam San

[Virtuoso-users] execution of a SQL procedure via sparql-auth

Hi, Is there a way to execute a SQL procedure via sparql-auth? or must I use the jdbc driver? Regards, Adam -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org!

Re: [Virtuoso-users] Adding virtuoso to rdf4j failed

ilter.java:62) org.eclipse.rdf4j.workbench.proxy.CookieCacheControlFilter.doFilter(CookieCacheControlFilter.java:53) note The full stack trace of the root cause is available in the Apache Tomcat/8.0.39 logs. = Any idea? Regards, Adam On Tue, Jun 20, 2017 at 2:00 PM,

Re: [Virtuoso-users] Adding virtuoso to rdf4j failed

gt; > Best > > Henrik > > Adam Sanchez schrieb am 23.06.2017 um 13:57: >> Hi Hugh, >> >> Finally I found my own solution. I am not very proud but it works at least. >> Well, I have to compile RDF4J (https://github.com/eclipse/rdf4j) >> inclu

Re: [Virtuoso-users] Adding virtuoso to rdf4j failed

followed are described here. https://github.com/asanchez75/rdf4j/wiki The changes were implemented in the branch virtuoso-7.2.4.2 Regards, Adam On Thu, Jun 22, 2017 at 11:15 AM, Adam Sanchez <a.sanche...@gmail.com> wrote: > Hi Hugh, > > I still got the same error I reporte

Re: [Virtuoso-users] Fixed: Correction: testing SPIN rules in Virtuoso 8

Thanks Kingsley! It is working now. Regards, Adam On Fri, Sep 15, 2017 at 2:16 AM, Kingsley Idehen <kide...@openlinksw.com> wrote: > On 9/14/17 5:08 PM, Kingsley Idehen wrote: > > On 9/14/17 4:52 PM, Kingsley Idehen wrote: > > On 9/13/17 10:28 AM, Adam Sanchez wrote: > &g

[Virtuoso-users] testing SPIN rules in Virtuoso 8

Hi all, I am testing SPIN rules in the demo version of Virtuoso 8 but I have still no success. I wrote a simple SPIN rule to compute the area of an instance of a class Rectangle given its width and its height. In this script you can see all the queries I used. This script must be executed in the

[Virtuoso-users] Virtuoso 8 - total number of output rows is always 25 or less

Hi all, I am testing Virtuoso 8. In a fresh installation, I launched this SPARQL query: SELECT count(*) WHERE {?s ?p ?o} and the result was 5644 triples in total. Then, I wanted to get only 1000 triples SELECT * WHERE {?s ?p ?o} LIMIT 1000 but the problem is that I get only (and always) 25

[Virtuoso-users] SPIN rules chaining in Virtuoso 8

Hi all, I have tried to chain two rules in Virtuoso 8 for testing. The steps are described in this link. https://gist.github.com/asanchez75/93ff4079819022bcd2cf42d4ec6bc335 The SPIN rules must compute the volume of an instance of the class Solid in two chained "steps": a) given the width and

Re: [Virtuoso-users] How to install isql?

not sure if this is what you need, but if you are using docker you can connect to the isql-v tool directly by doing docker exec -it ID_CONTAINER isql-v dba 'MYPASSWORD' 1 Best, Le mer. 29 avr. 2020 à 10:05, Luis de Sousa a écrit : > > Hi