Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-28741

Import/Export of ActiveObjects plugin data should store data as logical types instead of physical types

    XMLWordPrintable

Details

    Description

      Currently the XML backup of active objects data stores the data based on the physical schema specific to the database from which is was exported. This means that the import of the data into a different database which supports different data types could result in a type conflict.

      For example:
      Postgres supports the boolean type but Oracle does not. If we attempt to write a null value to the Oracle database and specify it as type boolean, an error will be thrown.

      To avoid this the data should be first converted into logical types before being stored in the XML file. This will mean it will be possible to convert the data types back to the appropriate physical type depending on the destination database.

      This issue has led to previous bug:
      https://jira.atlassian.com/browse/CONF-28272

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              dma@atlassian.com David Ma
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: