You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by "Ate Douma (JIRA)" <je...@portals.apache.org> on 2010/02/18 15:23:27 UTC
[jira] Closed: (JS2-1028) tables and columns names in db2
create-schema.sql are incorrect
[ 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: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org