Uploaded image for project: 'Infinispan'
  1. Infinispan
  2. ISPN-12124

OracleTableManager is overly conservative with object name max length

This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Critical Critical
    • 14.0.0.Final
    • 11.0.1.Final
    • Loaders and Stores
    • None

      The OracleTableManager limits the size of generated object names to 30 characters.  While 30 characters was the max object name length in 12.1 and earlier, since 12.2, this limit was increased to 128 characters.

      30 characters is prohibitively restrictive when it come to objects like the index name, the names for which are auto-generated based on the cache name, table name, and, in the case of the segment column, a long hard coded prefix (e.g. "segment_index") uses up nearly half of the available characters.

      Rather than fixed lengths per database type, Infinispan should leverage the DatabaseMetaData to determine the max size for a given database object, e.g. getMaxTableNameLength(), getMaxColumnNameLength(), etc.

              wburns@redhat.com Will Burns
              pferraro@redhat.com Paul Ferraro
              Archiver:
              rhn-support-adongare Amol Dongare

                Created:
                Updated:
                Resolved:
                Archived: