Uploaded image for project: 'Openfire'
  1. Openfire
  2. OF-1828

Oracle database does not permit empty string insertion into ofGroupProp

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.4.0
    • Fix Version/s: 4.4.1
    • Component/s: None
    • Labels:
      None

      Description

      This Problem still exists in oracle 11.2.0.2.

      The reason ist, that oracle saves empty Strings as NULL so the NOT NULL constraint on the column PROPVALUE is violated.

      It can be fixed with:

      ALTER TABLE ofGroupProp MODIFY propValue VARCHAR2(4000) NULL;

        Attachments

          Activity

            People

            Assignee:
            guus Guus der Kinderen
            Reporter:
            akrherz Daryl Herzmann
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: