Hi Lucas, do you use the latest version of Marmotta 3.3.0-SNAPSHOT? There are almost daily updates, especially to the SPARQL code. I just tried the query locally (of course without your data and with proper URLs for those you anonymized), but I cannot reproduce that error. In any case, you should turn on SPARQL debug logging in the logging configuration by setting the log level for SPARQL to "debug" and adding the Marmotta debug log to the SPARQL component. In the marmotta-debug.log you can then see how the query is translated to SQL and maybe send this to me?
Your Eclipse problem might come from the fact that you have old versions of Marmotta 3.3.0 SNAPSHOT in your local Maven repository. You should first run a "mvn clean install -DskipTests" in the most recent local checkout of the Marmotta GIT repository. Greetings, Sebastian 2014-11-04 11:43 GMT+01:00 Lucas Wagner <lucas.wag...@webdrone.fr>: > Hi, > > We are trying to ask a remote marmotta 3.3.0 triplestore using sparql > requests. In order to do that, we tried to use kiwi-triplestore and > kiwi-sparql to get connection. > > However,when we retieved the kiwi-triplestore 3.3.0 version, eclipse found > an error in KiWiConnection class. It seems that the > createCachKey function in LiteralsCommons class ask a Local type parameter > instead of a null parameter cast into string which is used. > > We also noticed that when we try to send a sparql request with clauses > like PREFIX, we get a NullPointerException in SQLBuilder.buildWhereClause() > from kiwi-sparql. In fact when the program try to retrieve SQLVariable sv > from variables attribute, it ask for a key like "-const-2" which does not > exist. I tried to add test on sv to execute the rest of the code only when > sv is not null and it seems to solve the problem. > > Are these problems come from code errors or did we make mistakes when we > retieved the project? > > When we try to execute the following sparql request, we also got an error. > Do you have any idea of the problem source? > > PREFIX webdrone:<url> > PREFIX xsd:<http://www.w3.org/2001/XMLSchema#> > PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#> > SELECT * > FROM <graph> > WHERE { > {?a rdf:type webdrone:typeA1 .} UNION {?a rdf:type webdrone:typeA2 .} > OPTIONAL { ?a webdrone:prop1 ?att1 . } > OPTIONAL { ?a webdrone:prop2 ?b . } > FILTER NOT EXISTS { ?a webdrone:prop3 webdrone:att3 . } . > OPTIONAL { ?a webdrone:prop4 ?att4a . } > OPTIONAL { ?b webdrone:prop4 ?att4b . } > FILTER((!bound(?att4a) || ?att4a !=\"false\"^^xsd:boolean) && > (!bound(?att4b) || ?att4b !=\"false\"^^xsd:boolean)) > } > > > org.openrdf.query.QueryEvaluationException: > org.postgresql.util.PSQLException: ERREUR: erreur de syntaxe sur ou près de > « FROM » > Position : 889 > at > org.openrdf.repository.sail.SailTupleQuery.evaluate(SailTupleQuery.java:67) > at > fr.webdrone.api.db.triplestore.dao.TestKiWiSparql.execSelectSparql(TestKiWiSparql.java:152) > at > fr.webdrone.api.db.triplestore.dao.TestKiWiSparql.main(TestKiWiSparql.java:84) > Caused by: org.openrdf.sail.SailException: > org.postgresql.util.PSQLException: ERREUR: erreur de syntaxe sur ou près de > « FROM » > Position : 889 > at > org.apache.marmotta.kiwi.sparql.sail.KiWiSparqlSailConnection.evaluate(KiWiSparqlSailConnection.java:96) > at > org.openrdf.repository.sail.SailTupleQuery.evaluate(SailTupleQuery.java:60) > ... 2 more > Caused by: org.openrdf.query.QueryEvaluationException: > org.postgresql.util.PSQLException: ERREUR: erreur de syntaxe sur ou près de > « FROM » > Position : 889 > at > org.apache.marmotta.kiwi.sparql.evaluation.KiWiEvaluationStrategyImpl.evaluateNative(KiWiEvaluationStrategyImpl.java:222) > at > org.apache.marmotta.kiwi.sparql.evaluation.KiWiEvaluationStrategyImpl.evaluate(KiWiEvaluationStrategyImpl.java:178) > at > org.openrdf.query.algebra.evaluation.impl.EvaluationStrategyImpl.evaluate(EvaluationStrategyImpl.java:583) > at > org.openrdf.query.algebra.evaluation.impl.EvaluationStrategyImpl.evaluate(EvaluationStrategyImpl.java:197) > at > org.openrdf.query.algebra.evaluation.impl.EvaluationStrategyImpl.evaluate(EvaluationStrategyImpl.java:662) > at > org.apache.marmotta.kiwi.sparql.evaluation.KiWiEvaluationStrategyImpl.evaluate(KiWiEvaluationStrategyImpl.java:123) > at > org.openrdf.query.algebra.evaluation.impl.EvaluationStrategyImpl.evaluate(EvaluationStrategyImpl.java:577) > at > org.openrdf.query.algebra.evaluation.impl.EvaluationStrategyImpl.evaluate(EvaluationStrategyImpl.java:197) > at > org.openrdf.query.algebra.evaluation.impl.EvaluationStrategyImpl.evaluate(EvaluationStrategyImpl.java:607) > at > org.openrdf.query.algebra.evaluation.impl.EvaluationStrategyImpl.evaluate(EvaluationStrategyImpl.java:197) > at > org.apache.marmotta.kiwi.sparql.sail.KiWiSparqlSailConnection.evaluate(KiWiSparqlSailConnection.java:93) > ... 3 more > Caused by: org.postgresql.util.PSQLException: ERREUR: erreur de syntaxe > sur ou près de « FROM » > Position : 889 > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302) > at > org.apache.marmotta.kiwi.sparql.persistence.KiWiSparqlConnection$1.call(KiWiSparqlConnection.java:101) > at > org.apache.marmotta.kiwi.sparql.persistence.KiWiSparqlConnection$1.call(KiWiSparqlConnection.java:1) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:744) > > Regards, > > Lucas WAGNER >
