-
1. Re: ORA-00936: missing expression
alwu-Oracle Apr 12, 2016 8:47 PM (in response to ruben.navarro)Hi,
Can you please send the exact version (size, date) of sdordfclient.jar? This feature has been there for many years. We even have a test case using "?date"
Thanks,
Zhe Wu -
2. Re: ORA-00936: missing expression
ruben.navarro Apr 18, 2016 2:51 PM (in response to alwu-Oracle)The size is 1.1 MB, the created date is the 2nd of February of this year (but I'm not sure if that is the date at which we uploaded it to our server...). At any case, the jar version will not be older than August 2015.
Can you check using the md5 sum? (which is 42e6958e9edacad97864b1cfad40b5bd).
Also, the problem was reproduced using 'resource' as a variable name. It seems like not all the reserved keywords (https://docs.oracle.com/database/121/SQLRF/ap_keywd001.htm#SQLRF55621) are covered by the fix.
Thank you!
Ruben
-
3. Re: ORA-00936: missing expression
alwu-Oracle Apr 19, 2016 6:50 PM (in response to ruben.navarro)Hi Ruben,
That's very strange. I just tried the following two against the Fuseki endpoint. Both work fine. I also inspected the trace and the renaming works as expected.
select ?s ?p ?date
where {?s ?p ?date}
limit 10
and
select ?s ?p ?resource
where {?s ?p ?resource}
limit 10
The Jena Adapter client library has a different checksum though.
% unzip -l rdf_semantic_graph_support_for_12c_and_jena211_protege_4.3.zip |grep sdordfclient_12c.jar
1160471 02-02-16 03:01 jar/sdordfclient_12c.jar
95681890a26a01033660ec51a8e54298 sdordfclient_12c.jar
Thanks,
Zhe Wu
-
4. Re: ORA-00936: missing expression
ruben.navarro Apr 20, 2016 8:57 AM (in response to alwu-Oracle)Hi Zhe!
Does this mean, that the renaming happens in the Jena adapter library and not directly in the database (by the SEM_MATCH function)? That might explain the problem.
At the moment, since older versions of the adapter had a bad performance with SPARQL 1.1 queries, the queries are sent directly to the server using SEM_MATCH (by-passing the Jena adapter logic). Do you think that might be the reason?
To my understanding, this was already fixed (the complete query is sent as-is to the database), so we wouldn't need that work around anymore. I'll look into that in the near future.
Regarding the jar, we are still using sdordfclient.jar (not sdordfclient_12c.jar).
Thanks!
Ruben
-
5. Re: ORA-00936: missing expression
alwu-Oracle Apr 20, 2016 4:31 PM (in response to ruben.navarro)Hi Ruben,
That's exactly the reason. The variable renaming happens in Jena Adapter.
We simply cannot send a complete SPARQL 1.0 (or 1.1) query to the DB for execution without any modifications. It does not work. "?date" is just one of the reasons.
Please try the latest Jena Adapter on MOS. Login to MOS and search for 22959933
Hope it helps,
Zhe Wu