On 12/03/2013 05:43 PM, Andy Seaborne wrote: > On 03/12/13 08:32, Andy Seaborne wrote: >> 500 is "Internal Server", an error from the server that means it went >> wrong. Without any more information, it is impossible to say why. >> >> Try other queries, both with and without SERVICE to see if anything >> works at all. Try also querying >> http://wifo5-04.informatik.uni-mannheim.de/sider/sparq directly. >> >> The standard installation of Fuseki logs all requests and errors at the >> server. If /drugbank/sparql has changed that, then I suggest undoing >> the change. >> Thanks a lot Andy, this is very helpful!
Best wishes, June > http://wifo5-04.informatik.uni-mannheim.de/drugbank/sparql and > .../sider/sparql are both Joseki server (v3.4.4) , not Fuseki. The > SPARQL engine is very out of date. > > Andy > >> Andy >> >> >> On 03/12/13 03:35, June wrote: >>> Hi Andy, >>> >>> I tried to configure log4j but failed, and I want to leave it at the >>> moment ... >>> >>> I debugged the codes, and I found that in QueryEngineHTTP.execSelect >>> method, the HTTPQuery actually is >>> >>> "http://wifo5-04.informatik.uni-mannheim.de/drugbank/sparql?query=PREFIX++drugbank%3A+%3Chttp%3A%2F%2Fwifo5-04.informatik.uni-mannheim.de%2Fdrugbank%2Fresource%2Fdrugbank%2F%3E%0APREFIX++sider%3A+%3Chttp%3A%2F%2Fwifo5-04.informatik.uni-mannheim.de%2Fsider%2Fresource%2Fsider%2F%3E%0APREFIX++owl%3A++%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E%0APREFIX++rdf%3A++%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0A%0ASELECT++%3Fdrug+%3Fenzyme+%3FsideEffect%0AWHERE%0A++%7B+%3Fdrug+rdf%3Atype+drugbank%3Adrugs+.%0A++++%3Fdrug+drugbank%3Aenzyme+%3Fenzyme+.%0A++++%3Fenzyme+rdf%3Atype+drugbank%3Aenzymes%0A++++SERVICE+%3Chttp%3A%2F%2Fwifo5-04.informatik.uni-mannheim.de%2Fsider%2Fsparql%3E%0A++++++%7B+%3FdrugInSider+owl%3AsameAs+%3Fdrug+.%0A++++++++%3FdrugInSider+rdf%3Atype+sider%3Adrugs+.%0A++++++++%3FdrugInSider+sider%3AsideEffect+%3FsideEffect+.%0A++++++++%3FsideEffect+rdf%3Atype+sider%3Aside_effects%0A++++++%7D%0A++%7D%0ALIMIT+++10%0A&timeout=10000"; >>> >>> which is simply transformed from the SPARQL query I wrote. If I open it >>> in a web browser, "HTTP ERROR 500" appears. >>> >>> It seems that the query is sent to one single endpoint which doesn't >>> support this SERVICE extension, instead of sending subqueries to >>> different SPARQL endpoints (which I guess is the way this SERVICE >>> extension works). >>> >>> So I guess maybe the codes I wrote are incorrect, but I didn't find the >>> correct way to do it. Could you please give me some helps? Many thanks >>> for that! >>> >>> Best wishes, >>> >>> June >>> >>> On 12/03/2013 02:09 AM, Andy Seaborne wrote: >>>> On 02/12/13 16:37, zhuman.private wrote: >>>>> Hi Andy, >>>>> >>>>> Sorry for the confusions. >>>>> http://wifo5-04.informatik.uni-mannheim.de/drugbank/sparql is a SPARQL >>>>> endpoint, so is http://wifo5-04.informatik.uni-mannheim.de/sider/sparql. >>>>> I tried queries separately on the two end points, and both of them are >>>>> working well. But not when querying on both of them. >>>>> >>>>> best regards >>>>> June >>>> June, >>>> >>>> What are the messages (and stacktrace) from the server log files? >>>> >>>> Andy >>>> >>>>>> 在 2013年12月2日，23:26，Andy Seaborne <[email protected]> 写道： >>>>>> >>>>>>> On 02/12/13 14:33, June wrote: >>>>>>> Dear list, >>>>>>> >>>>>>> I am trying to perform a federated SPARQL query by Jena arq for the >>>>>>> first time, and I am using the latest version of Jena. >>>>>>> >>>>>>> But I encountered a HTTPException:500 exception for executing the >>>>>>> following query. It will be very helpful if you can give me some tips >>>>>>> about this problem. >>>>>> What is http://wifo5-04.informatik.uni-mannheim.de/drugbank/sparql >>>>>> running? Is it Jena or another system? >>>>>> >>>>>> If it's Fuseki, what are the messages (and stacktrace) from the server >>>>>> log file? >>>>>> >>>>>> Andy >>>>>> >>>>>>> PREFIX drugbank: >>>>>>> <http://wifo5-04.informatik.uni-mannheim.de/drugbank/resource/drugbank/> >>>>>>> PREFIX sider: >>>>>>> <http://wifo5-04.informatik.uni-mannheim.de/sider/resource/sider/> >>>>>>> PREFIX owl: <http://www.w3.org/2002/07/owl#> >>>>>>> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> >>>>>>> >>>>>>> SELECT ?drug ?enzyme >>>>>>> WHERE >>>>>>> { ?drug rdf:type drugbank:drugs . >>>>>>> ?drug drugbank:enzyme ?enzyme . >>>>>>> ?enzyme rdf:type drugbank:enzymes >>>>>>> SERVICE <http://wifo5-04.informatik.uni-mannheim.de/sider/sparql> >>>>>>> { ?drugInSider owl:sameAs ?drug . >>>>>>> ?drugInSider rdf:type sider:drugs . >>>>>>> ?drugInSider sider:sideEffect ?sideEffect . >>>>>>> ?sideEffect rdf:type sider:side_effects >>>>>>> } >>>>>>> } >>>>>>> LIMIT 10 >>>>>>> >>>>>>> The codes I am using are: >>>>>>> >>>>>>> val query = QueryFactory.create(qStr) >>>>>>> val qexec = >>>>>>> QueryExecutionFactory.sparqlService("http://wifo5-04.informatik.uni-mannheim.de/drugbank/sparql";, >>>>>>> query) >>>>>>> try { >>>>>>> val results = qexec.execSelect() >>>>>>> while (results.hasNext()) { >>>>>>> val result = results.next >>>>>>> println(result.get("drug") + "\t" + result.get("enzyme"))// + >>>>>>> "\t" + result.get("sideEffect")) >>>>>>> } >>>>>>> } finally { >>>>>>> qexec.close(); >>>>>>> } >>>>>>> >>>>>>> Many thanks! >>>>>>> >>>>>>> Best wishes, >>>>>>> >>>>>>> June >>> -- ---------------- Zhu Man, (+86)13851764837 School of Computer Science & Engineering Southeast University, Nanjing
