Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-6102

Tables or columns from schemas or fields with long names should be shortened for Oracle

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.3 GA
    • Fix Version/s: 5.4.1
    • Component/s: Core VCS

      Description

      When using a schema or a field with a very long name (>30 chars), the table or column in Oracle is not using an appropriately shortened name which leads to the error below.

      The table and column name show be shortened below 30 chars, with no collision possible, but still be readable.

      ERROR [MCFConnectionInterceptor] Error occurred creating ManagedConnection for org.apache.geronimo.connector.outbound.ConnectionInfo@bec438
      org.nuxeo.ecm.core.storage.StorageException: java.sql.SQLException: ORA-00972: identifier is too long
      at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.createDatabase(JDBCMapper.java:133)
      at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCBackend.newMapper(JDBCBackend.java:156)
      at org.nuxeo.ecm.core.storage.sql.RepositoryImpl.getConnection(RepositoryImpl.java:335)
      ...
      Caused by: java.sql.SQLException: ORA-00972: identifier is too long
      ...
      at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1552)
      at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.createTables(JDBCMapper.java:199)
      at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.createDatabase(JDBCMapper.java:130)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                fguillaume Florent Guillaume
                Reporter:
                fguillaume Florent Guillaume
                Participants:
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: