I'll put a zipfile based on the jena-fuseki-1.0.0-SNAPSHOT in my public dropbox but need to write up a README file to indicate how to start it up. I probably won't get to it until tonight.
Will you be using it to connect to a VIVO instance? I've also been doing some work on the latest vivo release (1.6) that will be coming out soon. Among other things, it is going to have the beginnings of multi-language support and so far the only translation is into Spanish. In fact, the first production site that is based on the 1.6 code will likely be one that is being developed in Costa Rica and will be primarily be in Spanish. From the footer in your message it looks like you might be interested in having VIVO in French. If so, we're looking for someone that can help translate a message file (and some other labels that are used on the site) into French. -----Original Message----- From: Cyril HOLZER [mailto:[email protected]] Sent: Monday, September 09, 2013 5:17 AM To: [email protected] Subject: Re: fuseki, vivo, mysql. How to set this up? 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]> > 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]] > Sent: Friday, September 06, 2013 5:23 PM > To: [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"; } , > > "p": { "type": "uri" , "value": > > "http://www.w3.org/1999/02/22-rdf-syntax-ns#type"; } , > > "o": { "type": "uri" , "value": > > "http://www.w3.org/2002/07/owl#AnnotationProperty"; } , > > "g": { "type": "uri" , "value": > > "http://vitro.mannlib.cornell.edu/filegraph/tbox/vivo-dcterms-1.5.owl"; } > > } , > > { > > "s": { "type": "uri" , "value": > > "http://purl.org/dc/terms/source"; } , > > "p": { "type": "uri" , "value": > > "http://www.w3.org/1999/02/22-rdf-syntax-ns#type"; } , > > "o": { "type": "uri" , "value": > > "http://www.w3.org/2002/07/owl#AnnotationProperty"; } , > > "g": { "type": "uri" , "value": > > "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"; } , > > "p": { "type": "uri" , "value": > > "http://xmlns.com/foaf/0.1/lastName"; } , > > "o": { "datatype": "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"; } > > > > > > > > > > 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-ov > er-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 > > > > > > > > > > > > > >
