[JENA-1334] Unexpected SQLException [ java.sql.SQLSyntaxErrorException: ORA-00903

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Information Provided
• Affects Version/s: Jena 3.1.0, Fuseki 2.4.0
• Component/s: Fuseki, Jena
• Labels: ORA-00903 Oracle

Environment

Windows 10 (althought is reproduced in Windowss 2008 R2 too)
ORACLE 12c with direct mapping on views extracted from external sources

• Flags: Important
• Assignee: Unassigned
• Reporter: Nicolás Afonso Alonso
• Created: 10/May/17 12:37
• Updated: 10/May/17 19:28
• Resolved: 10/May/17 19:28

Description

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