[
https://issues.apache.org/jira/browse/JENA-1334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16004685#comment-16004685
]
Andy Seaborne commented on JENA-1334:
-------------------------------------
Nicolás,
"ORA-00903: invalid table name" -- that's implies it is in the
`oracle.spatial.rdf.client.jena.*` code which is supported by Oracle. Tables
are nothing to do with Apache Jena. The Apache Jena project does not have
access to the source code.Similarly, Fuseki modified by Oracle is supported by
Oracle.
> 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)
