[ https://jira.nuxeo.com/browse/NXP-8111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Florent Guillaume resolved NXP-8111. ------------------------------------ Resolution: Fixed Using database limits: - PostgreSQL: 63 - MySQL: 64 - SQLServer: 128 - Oracle: 30 (was already in the code) http://hg.nuxeo.org/nuxeo/nuxeo-core/rev/41957817646f > Fix SQL generation for long schema names > ---------------------------------------- > > Key: NXP-8111 > URL: https://jira.nuxeo.com/browse/NXP-8111 > Project: Nuxeo Enterprise Platform > Issue Type: Bug > Components: Core SQL Storage > Affects Versions: 5.4 > Environment: MySQL > Reporter: Florent Guillaume > Assignee: Florent Guillaume > Fix For: 5.5 > > > When using extremely long schema (or complex type) names, databases that have > limits on their system name lengths (table names, constraint names, index > names) may fail. > For instance MySQL: > {noformat} > Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: > java.sql.SQLException. message: Error post creating table: ALTER TABLE > `cmdist_initial_copy_external_participant_mailboxes` ADD INDEX > `cmdist_initial_copy_external_participant_mailboxes_id_hierarchy_fk` (`id`), > ADD CONSTRAINT > `cmdist_initial_copy_external_participant_mailboxes_id_hierarchy_fk` FOREIGN > KEY (`id`) REFERENCES `hierarchy` (`id`) ON DELETE CASCADE : Identifier name > 'cmdist_initial_copy_external_participant_mailboxes_id_hierarchy_fk' is too > long > at > org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.createTables(JDBCMapper.java:224) > at > org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.createDatabase(JDBCMapper.java:142) > ... 38 more > Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException. message: > Identifier name > 'cmdist_initial_copy_external_participant_mailboxes_id_hierarchy_fk' is too > long > {noformat} -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira _______________________________________________ ECM-tickets mailing list ECM-tickets@lists.nuxeo.com http://lists.nuxeo.com/mailman/listinfo/ecm-tickets