> > Next, I'll try federated query with dbPedia.org ... Last time I tried that > it failed because of dbPedia.org . >
Possibly due to https://stackoverflow.com/questions/61724903/service-against-virtuoso-dbpedia-gives-virtuoso-s0022-error-sq200-no-column ? > > Jean-Marc Vanel > < > http://semantic-forms.cc:9112/display?displayuri=http://jmvanel.free.fr/jmv.rdf%23me > > > +33 > (0)6 89 16 29 52 > > > Le lun. 20 juil. 2020 à 13:23, Andy Seaborne <[email protected]> a écrit : > > > Works for me. > > > > No database "TDB" > > > > tdbupdate --loc TDB --verbose --debug --update=U.ru > > > > tdbdump --loc TDB. > > > > 32903 quads. > > > > On 20/07/2020 11:28, Jean-Marc Vanel wrote: > > > This is what I tried : > > > > > > ~/apps/apache-jena-3.16.0/bin/tdbupdate --loc TDB --verbose --debug > > > --update=taxref-alignments.upd.rq > > > > > > Where file taxref-alignments.upd.rq contains : > > > > .ru > > > > but it works anyway. > > > > > > > > prefix wdtn: <http://www.wikidata.org/prop/direct-normalized/> > > > prefix owl: <http://www.w3.org/2002/07/owl#> > > > # Example of adding alignment triples from external SPARQL endpoint > > > INSERT { > > > GRAPH ?TARGET_GRAPH { > > > ?TAXON_TAXREF owl:sameAs ?TAXON_WKDT . > > > } } > > > WHERE { > > > BIND ( <urn:alignments:taxref> AS ?TARGET_GRAPH ) > > > SERVICE <https://query.wikidata.org/sparql> { > > > ?TAXON_WKDT wdtn:P3186 ?TAXON_TAXREF . > > > } } > > > > > > Result : the *TDB is not changed*; there are warnings that does not > seems > > > important: > > > > > > 11:57:23 WARN ResponseProcessCookies :: Invalid cookie header: > > > "Set-Cookie: > > > > Something from HTTP client. > > > > > WMF-Last-Access=20-Jul-2020;Path=/;HttpOnly;secure;Expires=Fri, 21 Aug > > 2020 > > > 00:00:00 GMT". Invalid 'expires' attribute: Fri, 21 Aug 2020 00:00:00 > GMT > > > 11:57:23 WARN ResponseProcessCookies :: Invalid cookie header: > > > "Set-Cookie: WMF-Last-Access-Global=20-Jul-2020;Path=/;Domain=. > > wikidata.org;HttpOnly;secure;Expires=Fri, > > > 21 Aug 2020 00:00:00 GMT". Invalid 'expires' attribute: Fri, 21 Aug > 2020 > > > 00:00:00 GMT > > > > > > I checked by several queries that TDB is not changed: > > > > > > SELECT * WHERE { GRAPH ?G { > > > ?S ?P <http://taxref.mnhn.fr/lod/taxon/29388/13.0> . > > > } } LIMIT 100 > > > > It is a subject in the database. > > > > <http://taxref.mnhn.fr/lod/taxon/29388/13.0> ?P ?O . > > > > > > > > SELECT * WHERE { GRAPH <urn:alignments:taxref> > > > {?S ?P ?O . } } LIMIT 100 > > > > works for me. > > > > > How could I debug this, not knowing whether Jena or Wikidata server is > at > > > fault ? > > > > > > > > > NOTE 1 : the corresponding, also federated, query gives results: > > > > > > prefix wdtn: <http://www.wikidata.org/prop/direct-normalized/> > > > SELECT * > > > WHERE { > > > SERVICE <https://query.wikidata.org/sparql> { > > > ?TAXON_WKDT wdtn:P3186 ?TAXON_TAXREF . > > > } > > > } LIMIT 44 > > > > > > when run by: > > > ~/apps/apache-jena-3.16.0/bin/rsparql --debug --verbose --service= > > > http://localhost:9000/sparql --query taxref-alignments.rq > > > > Not rsparql. > > > > sparql. > > > > You have sent the qhowl queyr to wikidata, not the SERVICE and LIMIT wil > > be done there. > > > > > where localhost is semantic_forms server (Jena based) ; > > > or by: > > > ~/apps/apache-jena-3.16.0/bin/rsparql --debug --verbose --service= > > > https://query.wikidata.org/sparql --query taxref-alignments.rq > > > > > > NOTE 2: I also tried with a more ordinary graph ( fictitious ) URI : < > > > http://alignments.taxref.org> > > > > > > Jean-Marc Vanel > > > < > > > http://semantic-forms.cc:9112/display?displayuri=http://jmvanel.free.fr/jmv.rdf%23me > > > > > > +33 (0)6 89 16 29 52 > > > Twitter: @jmvanel , @jmvanel_fr ; chat: irc:// > irc.freenode.net#eulergui > > > Chroniques jardin > > > < > > > http://semantic-forms.cc:1952/history?uri=http%3A%2F%2Fdbpedia.org%2Fresource%2FChronicle > > > > > > > > > -- *Thomas Francart* -* SPARNA* Web de *données* | Architecture de l'*information* | Accès aux *connaissances* blog : blog.sparna.fr, site : sparna.fr, linkedin : fr.linkedin.com/in/thomasfrancart tel : +33 (0)6.71.11.25.97, skype : francartthomas
