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. cdevconcepts842385.html
        3 kB
        Eric Radzinski
      2. derby678.diff
        2 kB
        Eric Radzinski

        Activity

        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.
        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.
        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.
        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
        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.
        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.

          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