Thank you Andy, it's works now !!!
Cordialement, Cyril Holzer 06.81.84.93.51 P *Adoptons ensemble des gestes responsables :* *N'imprimez ce message que si cela est indispensable*** ** ** " Ce courriel et les documents qui y sont attaches peuvent contenir des informations confidentielles. Si vous n'êtes pas le destinataire escompte, merci d'en informer l'expéditeur immédiatement et de détruire ce courriel ainsi que tous les documents attaches de votre système informatique. Toute divulgation, distribution ou copie du présent courriel et des documents attaches sans autorisation préalable de son émetteur est interdite."**** ** ** "This e-mail and any attached documents may contain confidential or proprietary information. If you are not the intended recipient, please advise the sender immediately and delete this e-mail and all attached documents from your computer system. Any unauthorized disclosure; distribution or copying hereof is prohibited."**** ** 2013/9/9 Andy Seaborne <[email protected]> > On 09/09/13 15:25, Cyril HOLZER wrote: > >> Thank you for your help. >> >> you can find my joseki configuration attached to this mail and my fuseki >> > > The list does not let attachments through. > > You don't need the ja:context mechanism and the sdb:graphName > <urn:x-arq:UnionGraph>. > > But as I said, I don't have an SDB setup available to me at the moment, > let along VIVO. > > Andy > > configuration file below : >> >> @prefix fuseki: >> <http://jena.apache.org/**fuseki#<http://jena.apache.org/fuseki#>> >> . >> @prefix rdf: >> <http://www.w3.org/1999/02/22-**rdf-syntax-ns#<http://www.w3.org/1999/02/22-rdf-syntax-ns#>> >> . >> @prefix rdfs: >> <http://www.w3.org/2000/01/**rdf-schema#<http://www.w3.org/2000/01/rdf-schema#>> >> . >> @prefix tdb: >> <http://jena.hpl.hp.com/2008/**tdb#<http://jena.hpl.hp.com/2008/tdb#>> >> . >> @prefix ja: >> <http://jena.hpl.hp.com/2005/**11/Assembler#<http://jena.hpl.hp.com/2005/11/Assembler#>> >> . >> @prefix sdb: >> <http://jena.hpl.hp.com/2007/**sdb#<http://jena.hpl.hp.com/2007/sdb#>> >> . >> @prefix jumble: >> <http://rootdev.net/vocab/**jumble#<http://rootdev.net/vocab/jumble#>> >> . >> >> [] rdf:type fuseki:Server ; >> ja:context [ >> ja:cxtName >> >> "http://jena.hpl.hp.com/SDB/**symbol#unionDefaultGraph<http://jena.hpl.hp.com/SDB/symbol#unionDefaultGraph>" >> ; >> ja:cxtValue "true" ] ; >> fuseki:services ( >> <#service> >> ) . >> >> [] ja:loadClass "com.hp.hpl.jena.sdb.SDB" . >> sdb:DatasetStore rdfs:subClassOf ja:RDFDataset . >> >> <#service> rdf:type fuseki:Service ; >> fuseki:name "VIVO" ; >> fuseki:serviceQuery "sparql" ; >> fuseki:serviceQuery "query" ; >> fuseki:serviceUpdate "update" ; # SPARQL query service -- /ds/update >> fuseki:serviceUpload "upload" ; # Nsdb:graphName >> <urn:x-arq:UnionGraph> on-SPARQL upload service >> fuseki:serviceReadGraphStore "get" sdb:graphName >> <urn:x-arq:UnionGraph> ; # Graph store protocol (read >> only) -- >> fuseki:dataset <#dataset> ; >> . >> >> <#dataset> rdf:type ja:RDFDataset ; >> ja:defaultGraph <#sdb-one-graph> ; >> . >> >> <#sdb-one-graph> a sdb:Model ; >> sdb:dataset <#sdb> ; >> sdb:graphName <urn:x-arq:UnionGraph> ; >> . >> >> <#sdb> rdf:type sdb:DatasetStore ; >> ## Number of concurrent connections allowed to this dataset. >> fuseki:poolSize 64 ; >> sdb:store <#store> . >> >> >> <#store> rdf:type sdb:Store ; >> rdfs:label "SDB" ; >> sdb:layout "layout2" ; >> sdb:connection >> [ rdf:type sdb:SDBConnection ; >> sdb:sdbHost "localhost" ; >> sdb:sdbType "MySQL" ; >> sdb:sdbName "vitrodb" ; >> sdb:sdbUser "vivo" ; >> sdb:sdbPassword "vivo" ; >> sdb:driver "com.mysql.jdbc.Driver" ; >> ] >> . >> >> >> >> Cordialement, >> >> Cyril Holzer >> >> 06.81.84.93.51 >> >> >> P/Adoptons ensemble des gestes responsables ://N'imprimez ce message que >> si cela est indispensable//____/ >> >> __ __ >> >> " Ce courriel et les documents qui y sont attaches peuvent contenir des >> informations confidentielles. Si vous n'êtes pas le destinataire >> escompte, merci d'en informer l'expéditeur immédiatement et de détruire >> ce courriel ainsi que tous les documents attaches de votre système >> informatique. Toute divulgation, distribution ou copie du présent >> courriel et des documents attaches sans autorisation préalable de son >> émetteur est interdite."____ >> >> __ __ >> >> "This e-mail and any attached documents may contain confidential or >> proprietary information. If you are not the intended recipient, please >> advise the sender immediately and delete this e-mail and all attached >> documents from your computer system. Any unauthorized disclosure; >> distribution or copying hereof is prohibited."____ >> >> __ >> >> >> >> 2013/9/9 Andy Seaborne <[email protected] <mailto:[email protected]>> >> >> How do you set it for Joseki? >> >> 1/ Pick the graph specifically out of the store via: >> >> <#dataset> rdf:type ja:RDFDataset ; >> ja:defaultGraph <#sdb-one-graph> ; >> . >> >> <#sdb-one-graph> a sdb:Model ; >> sdb:dataset <#sdb> ; >> sdb:graphName <urn:x-arq:UnionGraph> . >> >> 2/ Setting the ARQ context for the whole server: >> >> [] rdf:type fuseki:Server ; >> ja:context [ >> ja:cxtName >> >> "http://jena.hpl.hp.com/SDB/__**symbol#unionDefaultGraph<http://jena.hpl.hp.com/SDB/__symbol#unionDefaultGraph> >> >> <http://jena.hpl.hp.com/SDB/**symbol#unionDefaultGraph<http://jena.hpl.hp.com/SDB/symbol#unionDefaultGraph>>" >> ; >> ja:cxtValue "true" ] ; >> >> (sorry - I can't check this - no SDB setup to hand) >> >> Andy >> >> On 09/09/13 13:52, Cyril HOLZER wrote: >> >> Thank you Michel, but If you mean in your configuration file I >> don't see >> where you specify the graph. If you mean in the query I do not >> prefer >> specify it in this way because we have already developped an >> application >> based on Joseki and Vivo and we do not need to specify the >> graph. (just to >> set the propertie unionDefaultGraph in the configuration file) >> >> >> >> >> >> >> >> Cordialement, >> >> Cyril Holzer >> >> 06.81.84.93.51 >> >> >> P *Adoptons ensemble des gestes responsables :* *N'imprimez ce >> message que >> si cela est indispensable*** >> >> ** ** >> >> " Ce courriel et les documents qui y sont attaches peuvent >> contenir des >> informations confidentielles. Si vous n'êtes pas le destinataire >> escompte, >> merci d'en informer l'expéditeur immédiatement et de détruire ce >> courriel >> ainsi que tous les documents attaches de votre système >> informatique. Toute >> divulgation, distribution ou copie du présent courriel et des >> documents >> attaches sans autorisation préalable de son émetteur est >> interdite."**** >> >> ** ** >> >> "This e-mail and any attached documents may contain confidential >> or >> proprietary information. If you are not the intended recipient, >> please >> advise the sender immediately and delete this e-mail and all >> attached >> documents from your computer system. Any unauthorized disclosure; >> distribution or copying hereof is prohibited."**** >> >> ** >> >> >> 2013/9/9 Michel de Lange <[email protected] >> <mailto:michel_de_lange@yahoo.**co.uk<[email protected]> >> >> >> >> I am getting data now (with Fuseki 0.2.7 ), after following >> Andy's advice >> with the named graph. My mistake was that I did specify the >> graph, and so >> the query looked only at the default graph, and that is not >> where the data >> was. >> >> Cheers, >> >> >> Michel >> >> >> >> On 09/09/2013 21:17, Cyril HOLZER wrote: >> >> Hi John, >> >> I am interested with your build because I am trying to >> set up fuseki 0.2.7 >> and there is no data like Michel. >> I managed to run all with older versions (joseki and >> fuseki 0.2.2) but I >> can >> not do it with 0.2.7. >> >> thank you >> >> >> Cordialement, >> >> Cyril Holzer >> >> 06.81.84.93.51 >> >> >> P *Adoptons ensemble des gestes responsables :* >> *N'imprimez ce message que >> si cela est indispensable*** >> >> ** ** >> >> " Ce courriel et les documents qui y sont attaches >> peuvent contenir des >> informations confidentielles. Si vous n'êtes pas le >> destinataire escompte, >> merci d'en informer l'expéditeur immédiatement et de >> détruire ce courriel >> ainsi que tous les documents attaches de votre système >> informatique. Toute >> divulgation, distribution ou copie du présent courriel >> et des documents >> attaches sans autorisation préalable de son émetteur est >> interdite."**** >> >> ** ** >> >> "This e-mail and any attached documents may contain >> confidential or >> proprietary information. If you are not the intended >> recipient, please >> advise the sender immediately and delete this e-mail and >> all attached >> documents from your computer system. Any unauthorized >> disclosure; >> distribution or copying hereof is prohibited."**** >> >> ** >> >> >> 2013/9/7 John A. Fereira <[email protected] >> <mailto:[email protected]>> >> >> I don't know if this will help but I've got Fuseki + >> SDB +MySQL built >> >> based on the 0.2.6 code that we've been using for >> VIVO at Cornell (my >> boss >> was the original developer of VIVO. It has a few >> sample sparql queries >> for >> pulling data out of VIVO and include a startup >> script. It's all zipped >> up >> and can be deployed with just a small change to the >> configuration file >> >> I've got a ton of things on my plate right now but I >> want to build a >> version from the 1.0.0-SNAPSHOT (but thought I'd >> wait to see if json-ld >> gets in). >> >> In any case, you're welcome to my build (I've got it >> in a public folder >> in >> Dropbox) if you want it. >> >> -----Original Message----- >> From: Andy Seaborne [mailto:[email protected] >> <mailto:[email protected]>] >> Sent: Friday, September 06, 2013 5:23 PM >> To: [email protected] <mailto: >> [email protected]> >> Subject: Re: fuseki, vivo, mysql. How to set this up? >> >> On 06/09/13 10:41, Michel de Lange wrote: >> >> Hi Andy, >> >> >> Thank you very much for your help. I must >> confess that I barely know >> what I am doing, and I have been tearing my hear >> out, so I very much >> appreciate your help. >> >> I have run the query you gave me (select * WHERE >> { { ?a ?b ?c } UNION { >> GRAPH ?g { ?s ?p ?o } } } LIMIT 10) , and it >> returns heaps. Here is >> the top part: >> >> { >> "head": { >> "vars": [ "a" , "b" , "c" , "s" , "p" , >> "o" , "g" ] >> } , >> "results": { >> "bindings": [ >> { >> "s": { "type": "uri" , "value": >> >> "http://purl.org/dc/terms/**__**modified<http://purl.org/dc/terms/**__modified> >> >> <http://purl.org/dc/terms/****modified<http://purl.org/dc/terms/**modified> >> ><http://purl.org/dc/_**_terms/modified<http://purl.org/dc/__terms/modified> >> >> <http://purl.org/dc/terms/**modified<http://purl.org/dc/terms/modified> >> >>" >> } , >> "p": { "type": "uri" , "value": >> "http://www.w3.org/1999/02/22-** >> __**rdf-syntax-ns#type<http://www.w3.org/1999/02/22-__**rdf-syntax-ns#type> >> <http://www.w3.org/1999/02/22-** >> **rdf-syntax-ns#type <http://www.w3.org/1999/02/22-**rdf-syntax-ns#type> >> ><http://_**_www.w3.org/1999/02/22-rdf-__**syntax-ns#type<http://www.w3.org/1999/02/22-rdf-__syntax-ns#type> >> <http://www.w3.org/1999/02/22-** >> rdf-syntax-ns#type <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>>>" >> } , >> "o": { "type": "uri" , "value": >> "http://www.w3.org/2002/07/**_** >> _owl#AnnotationProperty<http://www.w3.org/2002/07/**__owl#AnnotationProperty> >> <http://www.w3.org/2002/07/**** >> owl#AnnotationProperty<http://www.w3.org/2002/07/**owl#AnnotationProperty> >> ><http:/**/__www.w3.org/2002/07/owl#__**AnnotationProperty<http://www.w3.org/2002/07/owl#__AnnotationProperty> >> <http://www.w3.org/2002/07/** >> owl#AnnotationProperty <http://www.w3.org/2002/07/owl#AnnotationProperty> >> >>" >> } , >> "g": { "type": "uri" , "value": >> "http://vitro.mannlib.cornell.** >> __**edu/filegraph/tbox/vivo-** >> dcterms-1.5.owl<http://vitro._**_ >> mannlib.cornell.edu/**filegraph/__tbox/vivo-dcterms-**1.5.owl<http://mannlib.cornell.edu/filegraph/__tbox/vivo-dcterms-1.5.owl> >> <http://vitro.mannlib.cornell.** >> edu/filegraph/tbox/vivo-**dcterms-1.5.owl<http://vitro.mannlib.cornell.edu/filegraph/tbox/vivo-dcterms-1.5.owl> >> >>" >> } >> } , >> { >> "s": { "type": "uri" , "value": >> >> "http://purl.org/dc/terms/**__**source<http://purl.org/dc/terms/**__source> >> >> <http://purl.org/dc/terms/****source<http://purl.org/dc/terms/**source> >> > >> >> <http://purl.org/dc/terms/__**source<http://purl.org/dc/terms/__source> >> >> <http://purl.org/dc/terms/**source<http://purl.org/dc/terms/source> >> >>" >> } , >> "p": { "type": "uri" , "value": >> "http://www.w3.org/1999/02/22-** >> __**rdf-syntax-ns#type<http://www.w3.org/1999/02/22-__**rdf-syntax-ns#type> >> <http://www.w3.org/1999/02/22-** >> **rdf-syntax-ns#type <http://www.w3.org/1999/02/22-**rdf-syntax-ns#type> >> ><http://_**_www.w3.org/1999/02/22-rdf-__**syntax-ns#type<http://www.w3.org/1999/02/22-rdf-__syntax-ns#type> >> <http://www.w3.org/1999/02/22-** >> rdf-syntax-ns#type <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>>>" >> } , >> "o": { "type": "uri" , "value": >> "http://www.w3.org/2002/07/**_** >> _owl#AnnotationProperty<http://www.w3.org/2002/07/**__owl#AnnotationProperty> >> <http://www.w3.org/2002/07/**** >> owl#AnnotationProperty<http://www.w3.org/2002/07/**owl#AnnotationProperty> >> ><http:/**/__www.w3.org/2002/07/owl#__**AnnotationProperty<http://www.w3.org/2002/07/owl#__AnnotationProperty> >> <http://www.w3.org/2002/07/** >> owl#AnnotationProperty <http://www.w3.org/2002/07/owl#AnnotationProperty> >> >>" >> } , >> "g": { "type": "uri" , "value": >> "http://vitro.mannlib.cornell.** >> __**edu/filegraph/tbox/vivo-** >> dcterms-1.5.owl<http://vitro._**_ >> mannlib.cornell.edu/**filegraph/__tbox/vivo-dcterms-**1.5.owl<http://mannlib.cornell.edu/filegraph/__tbox/vivo-dcterms-1.5.owl> >> <http://vitro.mannlib.cornell.** >> edu/filegraph/tbox/vivo-**dcterms-1.5.owl<http://vitro.mannlib.cornell.edu/filegraph/tbox/vivo-dcterms-1.5.owl> >> >>" >> } >> } , >> { >> >> >> >> and on it goes. There are no values for a, b and >> c anywhere I can see, >> but there are things I put into the db myself, >> such as this line (I >> took LIMIT 10 out of the query): >> >> "s": { "type": "uri" , "value": >> >> "http://vivo.mydomain.edu/**__**individual/n6763<http://vivo.mydomain.edu/**__individual/n6763> >> >> <http://vivo.mydomain.edu/****individual/n6763<http://vivo.mydomain.edu/**individual/n6763> >> ><http://vivo.**__mydomain.edu/individual/**n6763<http://mydomain.edu/individual/n6763> >> >> <http://vivo.mydomain.edu/**individual/n6763<http://vivo.mydomain.edu/individual/n6763> >> >>__" >> } , >> "p": { "type": "uri" , "value": >> >> "http://xmlns.com/foaf/0.1/**_**_lastName<http://xmlns.com/foaf/0.1/**__lastName> >> >> <http://xmlns.com/foaf/0.1/****lastName<http://xmlns.com/foaf/0.1/**lastName> >> ><http://xmlns.com/__**foaf/0.1/lastName<http://xmlns.com/__foaf/0.1/lastName> >> >> <http://xmlns.com/foaf/0.1/**lastName<http://xmlns.com/foaf/0.1/lastName> >> >>" >> } , >> "o": { "datatype": >> >> "http://www.w3.org/2001/**__**XMLSchema#string<http://www.w3.org/2001/**__XMLSchema#string> >> >> <http://www.w3.org/2001/****XMLSchema#string<http://www.w3.org/2001/**XMLSchema#string> >> ><http://www._**_w3.org/2001/XMLSchema#string >> >> <http://www.w3.org/2001/**XMLSchema#string<http://www.w3.org/2001/XMLSchema#string> >> >> >> " >> , >> "type": "typed-literal" , "value": "Tolstoy" } , >> "g": { "type": "uri" , "value": >> "http://vitro.mannlib.cornell.** >> __**edu/default/vitro-kb-2<**http:__//vitro.mannlib.** >> cornell.edu/__default/vitro-**kb-2<http://vitro.mannlib.cornell.edu/__default/vitro-kb-2> >> <http://vitro.mannlib.cornell.** >> edu/default/vitro-kb-2<http://vitro.mannlib.cornell.edu/default/vitro-kb-2> >> >>" >> } >> >> >> >> >> What does this imply for what I am doing? Why >> does this query return >> something, and mine does not? >> >> >> That means all the data is in named graphs. Maybe >> VIVO uses "union >> default graph" mode >> >> >> http://jena.apache.org/**__**documentation/sdb/**__** >> configuration.html#queries-<http://jena.apache.org/**__documentation/sdb/**__configuration.html#queries-> >> <http://jena.apache.org/****documentation/sdb/**** >> configuration.html#queries-<http://jena.apache.org/**documentation/sdb/**configuration.html#queries-> >> > >> **over-all-named-graphs<http:/**__/jena.apache.org/__ >> **documentation/sdb/__**configuration.html#queries-__** >> over-all-named-graphs<http://jena.apache.org/__documentation/sdb/__configuration.html#queries-__over-all-named-graphs> >> <http://jena.apache.org/**documentation/sdb/** >> configuration.html#queries-**over-all-named-graphs<http://jena.apache.org/documentation/sdb/configuration.html#queries-over-all-named-graphs> >> >> >> >> >> When you say "connect to one that isn't an SDB >> database": What makes a >> >> database//an SDB database? >> >> SDB uses it's own schema - it isn't a general SQL to >> RDF mapper. >> >> Mine is a MYSQL database, filled with tables by >> VIVO. Is that an SDB >> >> database? It has tables, such as jena_g1t0_reif, >> >> That is a Jena RDB table. The RDB storage system is >> no longer supported >> or included in Jena. Could it be unused and left >> over from an earlier >> time? >> >> and so on, and a table called triplets, and one >> called quads, >> >> >> They are SDB tables. >> >> so that is >> >> all quite promising. I wonder if there is some >> part missing, where I >> tell the sparql endpoint just how the queries >> should match the tables >> in my database. >> >> This may help: >> >> SELECT * { >> GRAPH <urn:x-arq:UnionGraph> { >> ?s ?p ?o >> } >> >> and asking the VIVO people what the setup is. >> >> Andy >> >> >> Thank you again, >> >> >> >> Michel >> >> >> >> >> >> >> >> >> >> >> >> >> >> >
