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

          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 Source Code