Problem with DB2 create and seed
--------------------------------
Key: JS2-1207
URL: https://issues.apache.org/jira/browse/JS2-1207
Project: Jetspeed 2
Issue Type: Bug
Components: Deployment
Affects Versions: 2.2.1, 2.2.2
Environment: Windows 7, DB2 9.7
Reporter: Frank Stalherm
I noticed two problems with the DB2 create and seed jobs.
If I use the db2 database name the tables MEDIATYPE_TO_MIMETYPE and
MEDIATYPE_TO_CAPABILITY are shortened to MEDIATYPE_MIMETYPE and
MEDIATYPE_CAPABILITY in the create script, which is fine. But if I try to seed
them the long table names are used.
This is no issue if I use db2v8 as the database name.
Problem here is that two index names are reused in the script, resulting in
SQLSTATE 42710 on second execution:
CREATE INDEX IX_FOLDER_TADATA_1 ON FOLDER_MENU_METADATA (MENU_ID);
CREATE UNIQUE INDEX UN_FOLDER_TADATA_1 ON FOLDER_MENU_METADATA (MENU_ID, NAME,
LOCALE, VALUE);
As a result the maven create targets are not working.
If I change this problem manually in the SQL script an initialize my database
manually, the seeding works fine.
On DB2 a page size of min. 8k is required. Is there is documentation or howto?
Default on Db2 is 4k.
This was not the case with JS 2.1.x . I thought I should mention this.
--
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]
