PocketQuery: How to query public SPARQL endpoint queries with Jena JDBC remote Drivers

Sebastian Tramp

We try to access public SPARQL endpoints with pocketquery and the Apache Jena JDBC remote drivers.

Unfortunately, the user is mandatory so we get the following

Error

Error rendering macro 'pocketquery' : org/apache/jena/atlas/web/auth/HttpAuthenticator

Here is a test setup

Database

Name: dbpedia

Url: jdbc:jena:remote:query=http://dbpedia.org/sparql

Driver: org.apache.jena.jdbc.remote.RemoteEndpointDriver

no user and pass

Query

Simple test query: 

SELECT DISTINCT ?class WHERE {?s a ?class} LIMIT 10

Felix Grund (Scandio)

Hi Sebastian!

Thank you for your interest in PocketQuery! This is a very interesting idea which is really new to me. At first, it seems that some of the Apache Jena libraries are missing. Did you put the Apache Jena libraries in your Confluence/Tomcat lib directory and restart Confluence? I think this should be it:
http://central.maven.org/maven2/org/apache/jena/jena-tdb/3.1.0/jena-tdb-3.1.0.jar

Also, can you set a log level in Confluence admin for "de.scandio.confluence.plugins.pocketquery" with level debug? Additionally please set the "debug" checkbox in the PocketQuery macro and paste the output here.

Regards, Felix (Scandio)