tables and columns names in db2 create-schema.sql are incorrect
----------------------------------------------------------------
Key: JS2-1028
URL: https://issues.apache.org/jira/browse/JS2-1028
Project: Jetspeed 2
Issue Type: Bug
Components: Persistence and DAO
Affects Versions: 2.2.0
Environment: DB2 UDB v9.5
Reporter: Vasiliy Lukin
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
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
