Details
-
Bug
-
Resolution: Won't Do
-
Major
-
None
-
None
Description
SourceForge Submitter: pilhuhn .
SQLUtil.fixConstraintName() uses the max table name
length to get the maximum length of a PK_constraint.
Unfortunately, there are databases, that have different
lenght for different things.
E.g.
The limit for table names in DB2 for Windows, OS/2 and
Unix was lifted to 128 in
v6. Column names can be 30 bytes long. Primary keys are
still limited to
18
So fcName() would check for 128 bytes, even if a column
can only be 30 chars in length.
Even worse: pks can only be 18 chars in length...
Possible solution:
Add even more entries to standardjbosscmp-jdbc.xml that
override the settings obtained from
DatabaseMetaData.getColumnNameLength().
This would be three optional elements
-table-name-length
-column-name-length
-primarykey-name-length
Are there other databases out, that are so broken?