[SYNCOPE-664] Empty string values not allowed with Oracle DB

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.2.3
• Fix Version/s: 1.2.4, 2.0.0-M1
• Component/s: core
• Environment: Oracle DB
• Assignee: Francesco Chicchiriccò
• Reporter: Francesco Chicchiriccò
• Created: 04/May/15 14:57
• Updated: 05/May/15 08:25
• Resolved: 04/May/15 15:59

Description

Due to a known (mis)behavior of Oracle DB, empty values for VARCHAR columns are treated as NULL.

This means that no "" values are allowed for any attribute value.

This problem was discovered when attempting to set the configuration parameter notificationjob.cronExpression to an empty string, in order to disable the NotificationJobs, but has a wider impact.