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

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Resolved Resolved
        2d 22h 35m 1 Catalina Wei 11/Sep/07 19:10
        Resolved Resolved Reopened Reopened
        1d 1h 22m 2 Catalina Wei 12/Sep/07 20:42
        Reopened Reopened Resolved Resolved
        5d 20h 39m 2 Kevin Sutter 18/Sep/07 17:12
        Resolved Resolved Closed Closed
        903d 2h 19m 1 Donald Woods 09/Mar/10 18:32
        Donald Woods made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Kevin Sutter made changes -
        Status Reopened [ 4 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        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.
        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.
        Catalina Wei made changes -
        Attachment OPENJPA-360.1.1.0.patch [ 12365666 ]
        Catalina Wei made changes -
        Attachment OPENJPA-360.1.0.x.patch [ 12365665 ]
        Catalina Wei made changes -
        Attachment OPENJPA-360.1.1.0.patch [ 12365666 ]
        Attachment OPENJPA-360.1.0.x.patch [ 12365665 ]
        Hide
        Catalina Wei added a comment -

        Use ThreadLocal for concurrent threads.

        Show
        Catalina Wei added a comment - Use ThreadLocal for concurrent threads.
        Catalina Wei made changes -
        Resolution Fixed [ 1 ]
        Status Resolved [ 5 ] Reopened [ 4 ]
        Assignee Kevin Sutter [ kwsutter ] Catalina Wei [ fancy ]
        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.
        Kevin Sutter made changes -
        Resolution Fixed [ 1 ]
        Status Reopened [ 4 ] Resolved [ 5 ]
        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).
        Kevin Sutter made changes -
        Status Resolved [ 5 ] Reopened [ 4 ]
        Resolution Fixed [ 1 ]
        Assignee Catalina Wei [ fancy ] Kevin Sutter [ kwsutter ]
        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.
        Catalina Wei made changes -
        Attachment OPENJPA-360.patch [ 12365411 ]
        Catalina Wei made changes -
        Fix Version/s 1.0.1 [ 12312687 ]
        Resolution Fixed [ 1 ]
        Status Open [ 1 ] Resolved [ 5 ]
        Fix Version/s 1.1.0 [ 12312344 ]
        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.
        Catalina Wei made changes -
        Field Original Value New Value
        Attachment OPENJPA-360.patch [ 12365411 ]
        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.
        Catalina Wei created issue -

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development