[infinispan-issues] [JBoss JIRA] (ISPN-12124) OracleTableManager is overly conservative with object name max length

[Paul Ferraro (Jira)]

Paul Ferraro created ISPN-12124:
-----------------------------------

             Summary: OracleTableManager is overly conservative with object name max length
                 Key: ISPN-12124
                 URL: https://issues.redhat.com/browse/ISPN-12124
             Project: Infinispan
          Issue Type: Enhancement
          Components: Loaders and Stores
    Affects Versions: 11.0.1.Final
            Reporter: Paul Ferraro


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").

Ideally, Infinispan should determine the max object name size at runtime based on the values returned by the DatabaseMetaData, e.g. getMaxTableNameLength(), getMaxColumnNameLength(), etc.



--
This message was sent by Atlassian Jira
(v7.13.8#713008)