Change Derby DB password

Question

I have already set a Derby DB password in Glassfish/Netbeans. I also checked the remember me checkbox.

Now I cannot change the password anymore.

Answer 1

To change the password you only have to execute:

call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.user.<my user name>', '<your new password>')

for example if you username is 'john' and you want you new password to be 'johnsnewpassword' you would call:

call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.user.john', 'johnsnewpassword')

Answer 2

Call

SYSCS_UTIL.SYSCS_RESET_PASSWORD('userid', 'newpassword');

See Built-in system procedures/ SYSCS_UTIL.SYSCS_RESET_PASSWORD in Java DB Reference Manual.