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

SAKAI_EVENT_DELAY.RESOURCE problems in Oracle

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.6.0
    • Fix Version/s: 2.6.0, 2.7.0
    • Component/s: Content
    • Labels:
      None

      Description

      The new SAKAI_EVENT_DELAY table has a field named "RESOURCE", which is causing problems with Oracle, where RESOURCE is a reserved word (see http://tinyurl.com/c8lg2v).

      There are two issues. First the table is not initially getting created by auto.ddl because of a syntax error in the creation script which needs to wrap the field name in double quotes. This was reported in SAK-15805, and the fix is available in SAK-14939, and has been applied to trunk, but not yet 2-6-x. I'm attaching that patch here as well, as I have verified that it solves this part of the problem.

      The second problem is that the hardcoded SQL in BaseEventDelayHanlder.java (http://tinyurl.com/can4ct) also doesn't treat the RESOURCE field name with double-quotes, and errors (ORA-00936: missing expression) occur when that SQL is run (eg, when a file is uploaded to Resources) because of the syntax confusion it causes.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  smarquard Stephen Marquard
                  Reporter:
                  daveadams David Adams
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  7 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code