[
https://issues.apache.org/jira/browse/DERBY-4328?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12744525#action_12744525
]
Knut Anders Hatlen commented on DERBY-4328:
-------------------------------------------
Option 2 sounds good for now.
One possible future enhancement could be to introduce a system procedure for
changing the boot password, which would help us around the quoting issues with
both of the existing approaches. Something like this:
PreparedStatement ps =
conn.prepareStatement("SYSCS_UTIL.SYSCS_CHANGE_BOOT_PASSWORD(?,?)");
ps.setString(1, " good, old password ");
ps.setString(2, "new, even better password ; 1,2,3,4 ");
ps.execute();
> The Developer's Guide falsely claims that you can use
> SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY to change the boot password on an
> encrypted database.
> --------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-4328
> URL: https://issues.apache.org/jira/browse/DERBY-4328
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Fix For: 10.5.3.0
>
> Attachments: derby-4328-01-aa-removeFalseReencryptionClaim.diff
>
>
> This claim is made in the section titled 'Changing the boot password'. If you
> try to run the example, you get this error:
> CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY( 'bootPassword', 'Thursday' ,
> 'Saturday');
> ERROR 42Y03: 'SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY' is not recognized as a
> function or procedure.
> The correct way to change the boot password is documented earlier on in the
> section titled 'Encrypting databases with a new boot password'. We should
> remove the section titled 'Changing the boot password'.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
