Derby
  1. Derby
  2. DERBY-5976

Document the new SQLWarning raised when trying to change the encryption state of an already booted database.

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.10.1.1
    • Fix Version/s: 10.10.1.1
    • Component/s: Documentation
    • Labels:
      None
    • Urgency:
      Normal

      Description

      After committing derby-5969-01-aa-warnEncryptionOnBootedDB.diff, we will want to adjust the user guides to clarify the following point:

      o If you are changing the encryption state of the database, be sure to check for SQLWarnings after the change. The change succeeded only if there were no SQLWarnings or SQLExceptions.

      I think that the following sections need to be touched up:

      Developer's Guide:

      o "Encrypting an existing unencrypted database"

      o "Encrypting databases with a new boot password"

      o "Encrypting databases with a new external encryption key"

      o "Decrypting an encrypted database"

      Reference Manual:

      o "dataEncryption=true attribute"

      o "newBootPassword=newPassword attribute"

      o "newEncryptionKey=key attribute"

      o "decryptDatabase=true attribute"

      1. DERBY-5976.diff
        6 kB
        Kim Haase
      2. DERBY-5976.stat
        0.3 kB
        Kim Haase
      3. DERBY-5976.zip
        18 kB
        Kim Haase

        Issue Links

          Activity

          Hide
          Rick Hillegas added a comment -

          Hi Kim,

          I committed derby-5969-01-aa-warnEncryptionOnBootedDB.diff so it's ok to go ahead and document this behavior now. Thanks.

          Show
          Rick Hillegas added a comment - Hi Kim, I committed derby-5969-01-aa-warnEncryptionOnBootedDB.diff so it's ok to go ahead and document this behavior now. Thanks.
          Hide
          Kim Haase added a comment -

          Thanks for the very clear spec, Rick! I'm attaching DERBY-5976.diff, DERBY-5976.stat, and DERBY-5976.zip, which I hope make the suggested changes. I made the language specific to each task.

          M src/ref/rrefattribdecryptdb.dita
          M src/ref/rrefattribnewencryptkey.dita
          M src/ref/rrefattrib15290.dita
          M src/ref/rrefattribnewbootpw.dita
          M src/devguide/cdevcsecuredecryptdb.dita
          M src/devguide/tdevcsecurenewextkey.dita
          M src/devguide/tdevcsecurenewbootpw.dita
          M src/devguide/tdevcsecureunencrypteddb.dita

          Show
          Kim Haase added a comment - Thanks for the very clear spec, Rick! I'm attaching DERBY-5976 .diff, DERBY-5976 .stat, and DERBY-5976 .zip, which I hope make the suggested changes. I made the language specific to each task. M src/ref/rrefattribdecryptdb.dita M src/ref/rrefattribnewencryptkey.dita M src/ref/rrefattrib15290.dita M src/ref/rrefattribnewbootpw.dita M src/devguide/cdevcsecuredecryptdb.dita M src/devguide/tdevcsecurenewextkey.dita M src/devguide/tdevcsecurenewbootpw.dita M src/devguide/tdevcsecureunencrypteddb.dita
          Hide
          Rick Hillegas added a comment -

          Thanks for the patch, Kim. Looks great. +1

          Show
          Rick Hillegas added a comment - Thanks for the patch, Kim. Looks great. +1
          Hide
          Kim Haase added a comment -

          Thanks, Rick, for the quick review.

          Committed patch DERBY-5976.diff to documentation trunk at revision 1406244.

          Show
          Kim Haase added a comment - Thanks, Rick, for the quick review. Committed patch DERBY-5976 .diff to documentation trunk at revision 1406244.
          Hide
          Kim Haase added a comment -

          Closing, since the changes have appeared in the Latest Alpha Manuals.

          Show
          Kim Haase added a comment - Closing, since the changes have appeared in the Latest Alpha Manuals.

            People

            • Assignee:
              Kim Haase
              Reporter:
              Rick Hillegas
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development