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 "Vasiliy Lukin (JIRA)" <je...@portals.apache.org> on 2009/06/07 14:32:07 UTC
[jira] Created: (JS2-1028) tables and columns names in db2
create-schema.sql are incorrect
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
[jira] Closed: (JS2-1028) tables and columns names in db2
create-schema.sql are incorrect
Posted by "Ate Douma (JIRA)" <je...@portals.apache.org>.
[ 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