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

XMLWordPrintable

    • 2
    • Severity 2 - Major

      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

            Assignee:
            Unassigned
            Reporter:
            David Ma
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: