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

Commons Tool SQL does not work on Oracle

    Details

    • Type: Bug
    • Status: RESOLVED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 19.0
    • Fix Version/s: 19.0
    • Component/s: Commons Tool
    • Labels:
      None
    • Test Plan:
      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

          Attachments

            Issue Links

              Activity

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code