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: