[prev in list] [next in list] [prev in thread] [next in thread] 

List:       jetspeed-user
Subject:    Errors in running PSML Database create script for DB2
From:       Mark.Miskiman () health ! gov ! ab ! ca
Date:       2002-01-31 20:51:50
[Download RAW message or body]

There are some issues running the dbpsml-schema.sql generated by the PSML
conversion routine for DB2:

1. The maximum length for any index or constraint identifier in DB2 is 18
characters. A generated identifier like JETSPEED_USER_PROFILE_PK needs to be
shortened to JETSPEED_USRPRF_PK or similar.

2. The generator puts in a line after the 'drop table xxxx' statements reading
"drop sequence if exists $table.SequenceName;". This must be an error in the
generation scipt as it is not DB2 syntax. In DB2, generated ids are tied to the
table directly so if you drop the table, the id generator is dropped
automatically. When you recreate the table, the generator id resets back to 1 by
default.

3. More of a cosmetic issue than an error - In DB2, when you mark a field as
UNIQUE, the system automatically creates a system index with all of those fields
as partners. If you try to manually create another index on the same fields, DB2
will detect this and give you an error: "The index was not created because the
index "SYSIBM.SQL020131134813940" already exists with the required description."

I don't know how to access the bug-tracker so if someone could enter these
issues....THX.

Mark



--
To unsubscribe, e-mail:   <mailto:jetspeed-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:jetspeed-user-help@jakarta.apache.org>

[prev in list] [next in list] [prev in thread] [next in thread]