[JS2-658] COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0107N The name "FK_PA_METADATA_FIELD_1" is too long. The maximum length is "18". SQLSTATE=42622

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 2.1
• Fix Version/s: 2.2.0
• Environment: Database -- DB2. JDK 1.5_06. Maven 1.0.2
• Assignee: Vivek Kumar
• Reporter: Mahesh Mohan
• Created: 08/Mar/07 11:12
• Updated: 20/Oct/08 11:02
• Resolved: 20/Oct/08 11:02

Description

When I try to generate and populate my DB2 Database for Jetspeed using Jetspeed-Maven Plugin I am getting the above exception. To fix this temporarly what I went along with was to identify the foreign keys with a name longer then 18 chars and make them shorter. This is a bit of manual step, but works fine with all the databases. So basically we need to get into the jetspeed plugin inside maven_repo (<maven installation dir>\maven_repo\cache\maven-jetspeed2-plugin-2.1-dev\plugin-resources\schema) and manually edit the schema xml's to overcome the above limitation.

Now, what I would like to know here is, whether this is a known issue or there is something wrong with my configurations moreover is there a better fix for this issue. And if this is a known issue, which release of Jetspeed-maven Plugin will have a solution for the same.

Any help on this regard will be greatly appreciated.

Regards
Mahesh