Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-40151

Commons Tool SQL does not work on Oracle

    XMLWordPrintable

Details

    • Bug
    • Status: RESOLVED
    • Major
    • Resolution: Fixed
    • 19.0
    • 19.0
    • Commons Tool
    • None
    • Hide

      Please add a Test Plan here.

      Show
      Please add a Test Plan here.

    Description

      The commons tool SQL does not work on Oracle. The SQL is hardcoded into the persistence class and contains table aliases using AS. This is not allowed in FROM clauses in Oracle.

      ref: https://stackoverflow.com/questions/4940530/oracle-can-you-assign-an-alias-to-the-from-clause

      The AS keyword should be able to be omitted for all databases. Ideally the persistence layer would not use hardcoded SQL though.

      Gliffy Diagrams

        Zeplin

          Attachments

            Issue Links

              Activity

                People

                  a.fish@lancaster.ac.uk Adrian Fish
                  steve.swinsburg Steve Swinsburg
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                    Created:
                    Updated:
                    Resolved:

                    Git Integration