1

I am trying to experiment with Jena using Java code. In this application, I only get 20 null values.

public class Movie_database {
    public static void main(String args[]) {
        Model model = ModelFactory.createDefaultModel();
        String sparqlQueryString = "PREFIX mdb: <http://data.linkedmdb.org/resource/movie/>"
                + "PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> "
                + "select ?director "
                + "where " 
                + "{ ?director     mdb:director_name ?value ."
                + "?director rdfs:label ?label .}  "
                + "LIMIT 20";
        Query query = QueryFactory.create(sparqlQueryString);
        QueryExecution qexec = QueryExecutionFactory.sparqlService("http://linkedmdb.org/sparql", query);
        ResultSet results = qexec.execSelect();
        while (results.hasNext()) {
            QuerySolution soln = results.nextSolution();
            Literal value = soln.getLiteral("value");
            System.out.println(value);
        }
    }
}

After all, it prints the 20 null values, so it finds something, but why is the value of ?value null?

Joshua Taylor
  • 84,998
  • 9
  • 154
  • 353
miniHessel
  • 778
  • 4
  • 15
  • 39
  • After a lot of debugging with the SPARQL query, it appears that the query is the problem. Tried with another query, and it works fine. Wierd, as I tried with a endpoint, and it returns the 20 values just fine. Anyways, anyone care to explain why the query is wrong? For my own learning curve. – miniHessel Aug 27 '13 at 12:05

1 Answers1

3

The query you've constructed is like the following, except that the following can be run in standalone fashion using Jena's command line tools, because I've used a service in the query.

PREFIX mdb: <http://data.linkedmdb.org/resource/movie/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

select ?director where {
  service <http://linkedmdb.org/sparql> {
    ?director mdb:director_name ?value ;
              rdfs:label ?label .
  }
}
limit 20

When I run this using the command line tools, these are the results (data.n3 is an empty file, because arq requires a --data argument, but the service ensures that the data is coming from the remote endpoint):

$ arq --data data.n3 --query query.sparql
----------------------------------------------------
| director                                         |
====================================================
| <http://data.linkedmdb.org/resource/director/1>  |
| <http://data.linkedmdb.org/resource/director/2>  |
| <http://data.linkedmdb.org/resource/director/3>  |
| <http://data.linkedmdb.org/resource/director/4>  |
| <http://data.linkedmdb.org/resource/director/5>  |
| <http://data.linkedmdb.org/resource/director/6>  |
| <http://data.linkedmdb.org/resource/director/7>  |
| <http://data.linkedmdb.org/resource/director/8>  |
| <http://data.linkedmdb.org/resource/director/9>  |
| <http://data.linkedmdb.org/resource/director/10> |
| <http://data.linkedmdb.org/resource/director/11> |
| <http://data.linkedmdb.org/resource/director/12> |
| <http://data.linkedmdb.org/resource/director/13> |
| <http://data.linkedmdb.org/resource/director/14> |
| <http://data.linkedmdb.org/resource/director/15> |
| <http://data.linkedmdb.org/resource/director/16> |
| <http://data.linkedmdb.org/resource/director/17> |
| <http://data.linkedmdb.org/resource/director/18> |
| <http://data.linkedmdb.org/resource/director/20> |
| <http://data.linkedmdb.org/resource/director/21> |
----------------------------------------------------

Notice that you've projected ?director, but not ?value or ?label. As a result there's no ?value variable bound when you do:

    Literal value = soln.getLiteral("value");
    System.out.println(value);

and you get a null result. You might be able to catch some of these kinds of mistakes using QuerySolution.contains. All you need to do is update your query to

select ?director ?value where { # you probably want ?label in here, too

or even 

select * where { # this would get all three variables

would suffice. Once you're selecting all three variables, you should get results like:

-------------------------------------------------------------------------------------------------------------
| director                                         | value                | label                           |
=============================================================================================================
| <http://data.linkedmdb.org/resource/director/1>  | "Chris Morris"       | "Chris Morris (Director)"       |
| <http://data.linkedmdb.org/resource/director/2>  | "Cecil B. DeMille"   | "Cecil B. DeMille (Director)"   |
| <http://data.linkedmdb.org/resource/director/3>  | "Michael Mann"       | "Michael Mann (Director)"       |
| <http://data.linkedmdb.org/resource/director/4>  | "Mustafa Altıoklar" | "Mustafa Altıoklar (Director)" |
| <http://data.linkedmdb.org/resource/director/5>  | "Robert J. Flaherty" | "Robert J. Flaherty (Director)" |
| <http://data.linkedmdb.org/resource/director/6>  | "Rex Ingram"         | "Rex Ingram (Director)"         |
| <http://data.linkedmdb.org/resource/director/7>  | "William Dickson"    | "William Dickson (Director)"    |
| <http://data.linkedmdb.org/resource/director/8>  | "Andrzej Å»uÅawski" | "Andrzej Å»uÅawski (Director)" |
| <http://data.linkedmdb.org/resource/director/9>  | "Max Reinhardt"      | "Max Reinhardt (Director)"      |
| <http://data.linkedmdb.org/resource/director/10> | "Willis O'Brien"     | "Willis O'Brien (Director)"     |
| <http://data.linkedmdb.org/resource/director/11> | "Frank Miller"       | "Frank Miller (Director)"       |
| <http://data.linkedmdb.org/resource/director/12> | "David Byrne"        | "David Byrne (Director)"        |
| <http://data.linkedmdb.org/resource/director/13> | "John G. Avildsen"   | "John G. Avildsen (Director)"   |
| <http://data.linkedmdb.org/resource/director/14> | "Leslie Howard"      | "Leslie Howard (Director)"      |
| <http://data.linkedmdb.org/resource/director/15> | "John Hughes"        | "John Hughes (Director)"        |
| <http://data.linkedmdb.org/resource/director/16> | "Karl Koch"          | "Karl Koch (Director)"          |
| <http://data.linkedmdb.org/resource/director/17> | "George Miller"      | "George Miller (Director)"      |
| <http://data.linkedmdb.org/resource/director/18> | "Michael Powell"     | "Michael Powell (Director)"     |
| <http://data.linkedmdb.org/resource/director/20> | "Joseph De Grasse"   | "Joseph De Grasse (Director)"   |
| <http://data.linkedmdb.org/resource/director/21> | "Yamanaka Sadao"     | "Yamanaka Sadao (Director)"     |
-------------------------------------------------------------------------------------------------------------
Joshua Taylor
  • 84,998
  • 9
  • 154
  • 353
  • Thank you for this great explanation. I trouble with "?director mdb:director_name ?value ". I can't understand why ?director can't be ?director, why do I have to call the object something else? Or am I totaly off track now? If I write ?director mdb:director_name ?director, I get nothing. – miniHessel Aug 28 '13 at 09:32
  • @user2715404 In a solution, each variable gets bound to exactly one value. The triple pattern `?x mdb:director_name ?y` in a SPARQL query matches a triple in the graph that has `mdb:director_name` as its predicate, and binds `?x` to the subject and `?y` to the object. A pattern `?x property ?x` can match a graph, but only in the case that the subject and object of the triple are the same, because only in that case can `?x` be bound to both, but still have a single value. Otherwise, `?x` would have to be bound to two _different_ values, which is not allowed. It doesn't matter what you call… – Joshua Taylor Aug 28 '13 at 13:06
  • @user2715404 …your variables, so you could use `?director_resource mdb:director_name ?director_name`, for instance. You also don't have to `select` all the variables that are used. For instance, to select just director names, you could `select ?name where { ?director mdb:director_name ?name }`, and the solutions in the results will only have a binding for `?name`. – Joshua Taylor Aug 28 '13 at 13:08