My Oracle Support Banner

Timeout In Long Running Query In Joseki Endpoint (Doc ID 1621875.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version and later
Information in this document applies to any platform.


A timeout is triggered in the jena adapter while executing a query:
"2013-12-19 10:12:09,911 [Timer-3] DEBUG oracle.spatial.rdf.client.jena.OracleLeanQueryIter []: requestCancel: called"

PREFIX xsd: <>

SELECT ?act ?cid ?oj ?ojid ?pf ?pl {
?act <http://xxx#resource_legal_published_in_official-journal> ?oj.
?oj <http://xxx#work_id_document> ?ojid.
?oj <http://xxx#official-journal_year> "2013"^^xsd:gYear.
?oj <http://xxx#date_publication> ?date_pub.
?e <http://xxx#expression_belongs_to_work> ?act.
?e <http://xxx#expression_uses_language> <>.
?m <http://xxx#manifests> ?e.
?m <http://xxx#manifestation_type> "print"^^xsd:string.
?m <http://xxx#page_first> ?pf.
?m <http://xxx#page_last> ?pl.
FILTER (?date_pub >= "1900-01-01"^^xsd:date)
FILTER (?date_pub <= "9999-12-31"^^xsd:date)
FILTER regex(?ojid, "^oj:", "i")
OPTIONAL{?act <http://xxx#id_celex> ?cid}

After setting the following JVM property:


some queries will complete execution but others still time out


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.