Nicolás Afonso Alonso created JENA-1334:
-------------------------------------------
Summary: Unexpected SQLException [
java.sql.SQLSyntaxErrorException: ORA-00903
Key: JENA-1334
URL: https://issues.apache.org/jira/browse/JENA-1334
Project: Apache Jena
Issue Type: Bug
Components: Fuseki, Jena
Affects Versions: Fuseki 2.4.0, Jena 3.1.0
Environment: Windows 10 (althought is reproduced in Windowss 2008 R2
too)
ORACLE 12c with direct mapping on views extracted from external sources
Reporter: Nicolás Afonso Alonso
We're using Fuseki 2.4.0 (Oracle supported one) to expose a Graph created with
a set of views.
These views are extracting information from external Oracle databases using a
external link (Public link) accessing to another Oracle database.
When we want to extract all predicated (
SELECT distinct ?predicate
WHERE {
?subject ?predicate ?object
}
An error ORA-00903 is trigger with a large stack.
Some potentially important notes:
1) views are extracting a subset of fields from external databases
2) the ORA-00903 issue is appearing also when views are created with an
InnerJoin.
3) Same SPARQL query works fine from Oracle SQL Development, which drives me to
think it's an issue on Jena or Fuseki
I'll post java exception stack in a comment
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
