Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-12560

In oracle, a directory property of which value is an empty string will be persisted as null and fetched to null

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Not A Bug
    • Affects Version/s: 5.7.3-SNAPSHOT
    • Fix Version/s: None
    • Component/s: Directory

      Description

      To figure out the problem, create a group without giving a group label.

      The value of the field "grouplabel" which is to be persisted is an empty string.

      In Oracle, empty string are persisted to null (fair enough). The problem is that when we fetch the persisted data, the value of the field "grouplabel" is not an empty string anymore but null.

      This is not really consistent with other db behaviours (such as h2, postgres) and could lead to some troubles.

      Note that here we use org.nuxeo.ecm.directory.sql.SQLSession. This behavior is not observed with org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession with oracle.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: