OpenJPA
  1. OpenJPA
  2. OPENJPA-77

Problems in default setting in DB2Dictionary , also missing support for DB2 z/OS platforms

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.9.7
    • Component/s: jdbc
    • Labels:
      None

      Description

      There are following problems:
      1. the default storeCharsAsNumbers = true, does not work well in DB2. Preferable default setting should be false.
      2. nextSequenceSQL() generates DB2 UDB specific SQLs which fails on DB2 z/OS platforms.
      3. lastGeneratedKeyQuery SQL string is applicable for DB2 UDB only, needs to provide DB2 z/OS specific SQL.
      4. bigintTypeName ="BIGINT" does not work for DB2 z/OS Version 8.
      5. characterColumnSize = 255 for default CHAR or VARCHAR fails on DB2 UDB platforms. DB2 UDB CHARACTER size limit is 254

        Activity

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open In Progress In Progress
        6h 6m 1 David Wisneski 10/Nov/06 00:02
        In Progress In Progress Resolved Resolved
        49d 15h 20m 1 Kevin Sutter 29/Dec/06 15:23
        Resolved Resolved Closed Closed
        214d 3h 34m 1 Kevin Sutter 31/Jul/07 18:58
        Kevin Sutter made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Patrick Linskey made changes -
        Fix Version/s 0.9.7 [ 12312340 ]
        David Wisneski made changes -
        Attachment OPENJPA-77.openjpa-jdbc.patch.txt [ 12344708 ]
        Kevin Sutter made changes -
        Resolution Fixed [ 1 ]
        Status In Progress [ 3 ] Resolved [ 5 ]
        Assignee David Wisneski [ wisneskid ] Kevin Sutter [ kwsutter ]
        Hide
        Kevin Sutter added a comment -

        Catalina provided a patch to me to check out. The changes looked good and the regression bucket ran just fine. The z/OS specific testing was done by another team.

        Show
        Kevin Sutter added a comment - Catalina provided a patch to me to check out. The changes looked good and the regression bucket ran just fine. The z/OS specific testing was done by another team.
        Hide
        Kevin Sutter added a comment -

        Catalina has provided a new private patch for this Issue which does not introduce the multiple database dictionaries for the various DB2 z/OS versions. It's much cleaner. I'm in the process of verifying it and will be committing the changes soon. Thanks.

        Show
        Kevin Sutter added a comment - Catalina has provided a new private patch for this Issue which does not introduce the multiple database dictionaries for the various DB2 z/OS versions. It's much cleaner. I'm in the process of verifying it and will be committing the changes soon. Thanks.
        David Wisneski made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        David Wisneski made changes -
        Attachment OPENJPA-77.openjpa-jdbc.patch.txt [ 12344708 ]
        David Wisneski made changes -
        Field Original Value New Value
        Assignee David Wisneski [ wisneskid ]
        Catalina Wei created issue -

          People

          • Assignee:
            Kevin Sutter
            Reporter:
            Catalina Wei
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development