Uploaded image for project: 'JOC - JobScheduler Operations Center'
  1. JOC - JobScheduler Operations Center
  2. JOC-604

Columns should be quoted in all SQL statements according the current JPA syntax

    XMLWordPrintable

Details

    Description

      Current Situation

      • Starting from JobScheduler release 1.12.0 a newer Hibernate version is used and therefore the JPA (Java Persistence API) version.
      • Changes in JPA to quote database columns are not considered.
      • This causes affects columns that make use of reserved words, e.g. "COMMENT" in table AUDIT_LOG.
        • The advanced search in JOC with a given search attribute for Reason does return an empty result set.

      Desired Behavior

      • Columns should be quoted in all SQL statements according the current JPA syntax.
      • Column names that use reserved words like COMMENT or START should be changed.
      • The advanced search for AUDIT_LOG entries should work even when searching for a specific Reason

      Attachments

        Activity

          People

            ur Uwe Risse
            oh Oliver Haufe
            Santiago Aucejo Petzoldt Santiago Aucejo Petzoldt
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: