[
https://issues.apache.org/jira/browse/JS2-1028?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ate Douma closed JS2-1028.
--------------------------
Resolution: Invalid
Jetspeed 2.2.0 already provides support for both db2 v7 and v8+
The table and column names are not truncated if you use database type db2v8
(you must have been using "just" db2 which is for db2 v7).
> 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]
