[jira] [Closed] (JENA-1334) Unexpected SQLException [ java.sql.SQLSyntaxErrorException: ORA-00903

["Andy Seaborne (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/JENA-1334?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andy Seaborne closed JENA-1334.
-------------------------------
    Resolution: Information Provided

> 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: Jena 3.1.0, Fuseki 2.4.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
>              Labels: ORA-00903, Oracle
>
> 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)