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

Quotes in hierarchy title not escaped in SQL query

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: RESOLVED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.9.4 [Tentative]
    • Fix Version/s: None
    • Component/s: DelegatedAccess
    • Labels:
      None
    • Previous Issue Keys:
      DAC-53

      Description

      We are upgrading Delegated Access to 3.0 and are experiencing SQLExceptions in DelegatedAccessDaoImpl when running the Delegated Access Site Hierarchy Job because some of our hierarchy categories contain apostrophes that are not escaped when building the query.

      I've attached a patch that resolves the issue for our case, though it only escapes single quotes.

        Gliffy Diagrams

          Zeplin

            Attachments

              Activity

                People

                • Assignee:
                  baholladay Bryan Holladay
                  Reporter:
                  curtisvo Curtis van Osch
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Integration