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

Support migration from a case-sensitive database (including HSQL) to a case-insensitive database

XMLWordPrintable

    • 10
    • We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      NOTE: This suggestion is for Confluence Server. Using Confluence Cloud? See the corresponding suggestion.

      Different databases have different settings for case sensitivity. The case sensitivity of the database is usually set through the collation that it uses.

      The default embedded database (HSQL) in Confluence is a CASE SENSITIVE database. When you attempt to migrate this data to an external database that is set up with a case insensitive collation, you may experience problems.

      You may encounter this error for example:

      The data import process reported the duplicate error on the wrong object:
      Import failed. (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Duplicate entry 'OSUser_user-11-confluence.prefs.email.notify' for key 1

      or

      2007-02-21 15:02:03,676 ERROR [sf.hibernate.util.JDBCExceptionReporter] logExceptions Violation of PRIMARY KEY constraint 'PK_OS_PROPERTYENTRY_619B8048'. Cannot insert duplicate key in object 'OS_PROPERTYENTRY'.
      2007-02-21 15:02:03,692 ERROR [confluence.importexport.impl.ReverseDatabinder] endElement net.sf.hibernate.exception.ConstraintViolationException: could not insert: [bucket.user.propertyset.BucketPropertySetItem#bucket.user.propertyset.BucketPropertySetItem@d88630dc]
      net.sf.hibernate.exception.ConstraintViolationException: could not insert: [bucket.user.propertyset.BucketPropertySetItem#bucket.user.propertyset.BucketPropertySetItem@d88630dc]
      at net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:62)
      at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)

              Unassigned Unassigned
              mjensen m@ (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: