-
Fix
-
-
Major
-
Resolution:
Fixed
-
None
-
-
-
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