Uploaded image for project: 'Apache Jena'
  1. Apache Jena
  2. JENA-1334

Unexpected SQLException [ java.sql.SQLSyntaxErrorException: ORA-00903

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Information Provided
    • Jena 3.1.0, Fuseki 2.4.0
    • None
    • Fuseki, Jena
    • Windows 10 (althought is reproduced in Windowss 2008 R2 too)
      ORACLE 12c with direct mapping on views extracted from external sources

    • Important

    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

      Attachments

        Activity

          People

            Unassigned Unassigned
            nicolas.afonso@schneider-electric.com Nicolás Afonso Alonso
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: