[
https://issues.apache.org/jira/browse/JS2-1207?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Frank Stalherm updated JS2-1207:
--------------------------------
Priority: Minor (was: Major)
> 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
> Priority: Minor
>
> 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]
