OpenJPA
  1. OpenJPA
  2. OPENJPA-360

SQL FOR UPDATE OF incorrectly generated for DB2/NT SQL0816

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 1.0.0, 1.0.1, 1.1.0
    • Fix Version/s: 1.0.1, 1.1.0
    • Component/s: sql
    • Labels:
      None

      Description

      "FOR UPDATE OF" string incorrectly generated for DB2 UDB version 8.1 or earlier and DB2 ISeries V5R3 or earlier.
      Should generate "FOR UPDATE"

        Activity

        Hide
        Catalina Wei added a comment -

        Fix UPDATE OF clause for DB2 UDB Version 8.1 or earlier and DB2 Iseries V5R3 or earlier.

        Show
        Catalina Wei added a comment - Fix UPDATE OF clause for DB2 UDB Version 8.1 or earlier and DB2 Iseries V5R3 or earlier.
        Hide
        Catalina Wei added a comment -

        This problem is fixed in svn commit: r574464 - in /openjpa/trunk: and svn commit: r574653 - in /openjpa/branches/1.0.x.

        Show
        Catalina Wei added a comment - This problem is fixed in svn commit: r574464 - in /openjpa/trunk: and svn commit: r574653 - in /openjpa/branches/1.0.x.
        Hide
        Kevin Sutter added a comment -

        Temporarily re-opening this issue to clean up the testcases to remove the dependency on DB2 drivers... Our unit tests need to run with Derby only. If we want to run with DB2, then a different profile should be defined and specified. I have made the changes and am currently testing them with Derby. I'll commit the changes shortly.

        Show
        Kevin Sutter added a comment - Temporarily re-opening this issue to clean up the testcases to remove the dependency on DB2 drivers... Our unit tests need to run with Derby only. If we want to run with DB2, then a different profile should be defined and specified. I have made the changes and am currently testing them with Derby. I'll commit the changes shortly.
        Hide
        Kevin Sutter added a comment -

        Testcase updates resolved via SVN revision r575008 (both releases).

        Show
        Kevin Sutter added a comment - Testcase updates resolved via SVN revision r575008 (both releases).
        Hide
        Catalina Wei added a comment -

        As Patick pointed out that transient variable should not be used in DBDictionary, because dict is used by cuncurrent threads.

        Show
        Catalina Wei added a comment - As Patick pointed out that transient variable should not be used in DBDictionary, because dict is used by cuncurrent threads.
        Hide
        Catalina Wei added a comment -

        Use ThreadLocal for concurrent threads.

        Show
        Catalina Wei added a comment - Use ThreadLocal for concurrent threads.
        Hide
        Catalina Wei added a comment -

        transient Select sel is removed.
        fix committed under revision 575080.

        Show
        Catalina Wei added a comment - transient Select sel is removed. fix committed under revision 575080.
        Hide
        Kevin Sutter added a comment -

        Resolved in both 1.0.1 and 1.1.0 streams.

        Show
        Kevin Sutter added a comment - Resolved in both 1.0.1 and 1.1.0 streams.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development