[JS2-1028] tables and columns names in db2 create-schema.sql are incorrect

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 2.2.0
• Component/s: Persistence and DAO
• Environment: DB2 UDB v9.5
• Assignee: Unassigned
• Reporter: Vasiliy Lukin
• Created: 07/Jun/09 12:31
• Updated: 18/Feb/10 14:21
• Resolved: 18/Feb/10 14:21

Description

Names of columns and tables are cut( MEDIATYPE_TO_CAPABILITY - > MEDIATYPE_PABILITY)
maybe because in jetspeed-2.1 constraints names were longer than 18 bytes.

In DB2 v8.2 only constraints (index, unique constraint, foreign key) names must be shorter than 18 bytes, columns and tables names are limited to 128 bytes.
In v9.5 constraints names length are limited to 128.
here db2 v9.5 limits:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.sql.ref.doc/doc/r0001029.html