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