You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jena.apache.org by Jean-Marc Vanel <je...@gmail.com> on 2020/07/20 10:28:48 UTC
Federated update query with SERVICE Wikidata : no change in TDB (1)
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 :
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:
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
SELECT * WHERE { GRAPH <urn:alignments:taxref>
{?S ?P ?O . } } LIMIT 100
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
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>
Re: Federated update query with SERVICE Wikidata : no change in TDB (1)
Posted by Thomas Francart <th...@sparna.fr>.
>
> 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 <an...@apache.org> 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
Re: Federated update query with SERVICE Wikidata : no change in TDB (1)
Posted by Jean-Marc Vanel <je...@gmail.com>.
Sorry , I forgot that my already filled database on my laptop, although
behaving good so far, has every reason to be roten, as it is used for tests
and sometimes stopped abruptly .
Otherwise, everything is fine with federated query with Wikidata as the
service !
Next, I'll try federated query with dbPedia.org ... Last time I tried that
it failed because of dbPedia.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
Le lun. 20 juil. 2020 à 13:23, Andy Seaborne <an...@apache.org> 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
> >
> >
>
Re: Federated update query with SERVICE Wikidata : no change in TDB
(1)
Posted by Andy Seaborne <an...@apache.org>.
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>
>