[
https://issues.apache.org/jira/browse/JENA-1334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16004883#comment-16004883
]
Nicolás Afonso Alonso commented on JENA-1334:
---------------------------------------------
Oh... I understand.
As queries are executed nicely in SPAQRL editor on SQL Developer tool, I
assumed it was an issue in Jena/Fuseki. i also assumed Oracle was part of JENA
project and someon would take the issue from here.
> 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)
