Jetspeed 2
  1. Jetspeed 2
  2. 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

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: 2.1
    • Fix Version/s: 2.2.0
    • Component/s: None
    • Labels:
      None
    • Environment:
      Database -- DB2. JDK 1.5_06. Maven 1.0.2

      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

        Activity

        Mahesh Mohan created issue -
        Ate Douma made changes -
        Field Original Value New Value
        Fix Version/s 2.2-dev [ 12312318 ]
        Priority Major [ 3 ] Minor [ 4 ]
        Fix Version/s 2.1 [ 12310617 ]
        Hajo Birthelmer made changes -
        Attachment patch-JS2-658-schema.txt [ 12353328 ]
        David Sean Taylor made changes -
        Assignee David Sean Taylor [ taylor ]
        Ate Douma made changes -
        Assignee David Sean Taylor [ taylor ] Ate Douma [ adouma ]
        Ate Douma made changes -
        Priority Minor [ 4 ] Critical [ 2 ]
        Ate Douma made changes -
        Assignee Ate Douma [ adouma ] Vivek Kumar [ firevelocity ]
        Vivek Kumar made changes -
        Resolution Fixed [ 1 ]
        Status Open [ 1 ] Closed [ 6 ]

          People

          • Assignee:
            Vivek Kumar
            Reporter:
            Mahesh Mohan
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development