Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-360

SQL FOR UPDATE OF incorrectly generated for DB2/NT SQL0816

        Details

        • Type: Bug
        • Status: Closed
        • Priority: 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

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            fancy Catalina Wei added a comment -

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

            Show
            fancy Catalina Wei added a comment - Fix UPDATE OF clause for DB2 UDB Version 8.1 or earlier and DB2 Iseries V5R3 or earlier.
            Hide
            Permalink
            fancy 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
            fancy 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
            Permalink
            kwsutter 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
            kwsutter 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
            Permalink
            kwsutter Kevin Sutter added a comment -

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

            Show
            kwsutter Kevin Sutter added a comment - Testcase updates resolved via SVN revision r575008 (both releases).
            Hide
            Permalink
            fancy 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
            fancy 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
            Permalink
            fancy Catalina Wei added a comment -

            Use ThreadLocal for concurrent threads.

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

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

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

            Resolved in both 1.0.1 and 1.1.0 streams.

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

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Development