Derby
  1. Derby
  2. DERBY-678

derby documentation does not reflect changes to update lock behavior

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.2.0
    • Fix Version/s: 10.1.3.1
    • Component/s: Documentation
    • Labels:
      None

      Description

      The following section in the developers guide on update locks needs to be changed from:
      When a user-defined update cursor (created with the FOR UPDATE clause) reads data, its transaction obtains an update lock on the data. If the user-defined update cursor updates the data, the update lock is converted to an exclusive lock. If the cursor does not update the row, when the transaction steps through to the next row, transactions using the TRANSACTION_READ_COMMITTED isolation level release the lock, and transactions using the TRANSACTION_SERIALIZABLE or TRANSACTION_REPEATABLE_READ isolation level downgrade it to a shared lock until the transaction is committed. (For update locks, the TRANSACTION_READ_UNCOMMITTED isolation level acts the same way as TRANSACTION_READ_COMMITTED.)

      to:
      When a user-defined update cursor (created with the FOR UPDATE clause) reads data, its transaction obtains an update lock on the data. If the user-defined update cursor updates the data, the update lock is converted to an exclusive lock. If the cursor does not update the row, when the transaction steps through to the next row, transactions using the TRANSACTION_READ_COMMITTED isolation level release the lock.
      (For update locks, the TRANSACTION_READ_UNCOMMITTED isolation level acts the same way as TRANSACTION_READ_COMMITTED.)

      1. derby678.diff
        2 kB
        Eric Radzinski
      2. cdevconcepts842385.html
        3 kB
        Eric Radzinski

        Activity

        Mike Matrigali created issue -
        Hide
        Eric Radzinski added a comment -

        Attached patch address the bug that's identified in this issue. HTML file is included for review.

        Show
        Eric Radzinski added a comment - Attached patch address the bug that's identified in this issue. HTML file is included for review.
        Eric Radzinski made changes -
        Field Original Value New Value
        Attachment cdevconcepts842385.html [ 12322363 ]
        Attachment derby678.diff [ 12322362 ]
        Hide
        Mike Matrigali added a comment -

        the attached .html for this fix looks good to me.

        Show
        Mike Matrigali added a comment - the attached .html for this fix looks good to me.
        Andrew McIntyre made changes -
        Other Info [Patch available]
        Hide
        Jean T. Anderson added a comment -

        Committed patch derby678.diff, revision 372919. Files modified:
        $ svn status
        M src/devguide/cdevconcepts842385.dita

        Show
        Jean T. Anderson added a comment - Committed patch derby678.diff, revision 372919. Files modified: $ svn status M src/devguide/cdevconcepts842385.dita
        Jean T. Anderson made changes -
        Resolution Fixed [ 1 ]
        Status Open [ 1 ] Resolved [ 5 ]
        Assignee Jean T. Anderson [ jta ]
        Hide
        Jean T. Anderson added a comment -

        No problems have been reported with the committed patch, so closing.

        Show
        Jean T. Anderson added a comment - No problems have been reported with the committed patch, so closing.
        Jean T. Anderson made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Hide
        Jean T. Anderson added a comment -

        Reopen to merge fix to 10.1.3.

        Show
        Jean T. Anderson added a comment - Reopen to merge fix to 10.1.3.
        Jean T. Anderson made changes -
        Status Closed [ 6 ] Reopened [ 4 ]
        Resolution Fixed [ 1 ]
        Hide
        Jean T. Anderson added a comment -

        Merged from 10.2, committed revision 397012.

        Show
        Jean T. Anderson added a comment - Merged from 10.2, committed revision 397012.
        Jean T. Anderson made changes -
        Status Reopened [ 4 ] Closed [ 6 ]
        Resolution Fixed [ 1 ]
        Fix Version/s 10.1.3.0 [ 12310616 ]
        Fix Version/s 10.2.0.0 [ 11187 ]
        Gavin made changes -
        Workflow jira [ 12343387 ] Default workflow, editable Closed status [ 12801355 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Resolved Resolved
        84d 23h 24m 1 Jean T. Anderson 28/Jan/06 02:21
        Resolved Resolved Closed Closed
        30d 23h 33m 1 Jean T. Anderson 28/Feb/06 01:54
        Closed Closed Reopened Reopened
        57d 4h 9m 1 Jean T. Anderson 26/Apr/06 07:03
        Reopened Reopened Closed Closed
        1m 6s 1 Jean T. Anderson 26/Apr/06 07:04

          People

          • Assignee:
            Jean T. Anderson
            Reporter:
            Mike Matrigali
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development