[OPENJPA-1596] Index name too long for DB2 zOS

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0-beta2
• Fix Version/s: 2.0.0-beta3
• Component/s: jdbc
• Assignee: Fay Wang
• Reporter: Fay Wang
• Created: 23/Mar/10 18:39
• Updated: 02/Jun/10 19:23
• Resolved: 23/Mar/10 19:29

Description

When running JPA on DB2 zOS v9, the following exception is thrown:

Exception in thread "main" <openjpa-2.0.0-SNAPSHOT-r422266:832587 nonfatal user error> org.apache.openjpa.persistence.ArgumentException: Index name "OPENJPA_SEQUENCE_TABLE_IDX" is 26-character long. The database allows maximum 18-character for an index name.
at org.apache.openjpa.jdbc.sql.DBDictionary.checkNameLength(DBDictionary.java:5021)
at org.apache.openjpa.jdbc.sql.DBDictionary.getCreateIndexSQL(DBDictionary.java:3429)
at org.apache.openjpa.jdbc.schema.SchemaTool.createIndex(SchemaTool.java:1017)
at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:565)
at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:345)
at org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:322)
at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:501)
at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453)
at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:155)
at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)

Issue Links

• is blocked by: OPENJPA-1679 Index name too long for DB2 zOS when schema is present