portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vasiliy Lukin (JIRA)" <jetspeed-...@portals.apache.org>
Subject [jira] Created: (JS2-1028) tables and columns names in db2 create-schema.sql are incorrect
Date Sun, 07 Jun 2009 12:32:07 GMT
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


Mime
View raw message