Change Derby DB password

derby change-password
Robot Mess picture Robot Mess · Feb 21, 2013 · Viewed 11.8k times · Source

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

Robot Mess picture Robot Mess · Feb 21, 2013

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')

Related questions

org.hibernate.hql.internal.ast.QuerySyntaxException: table is not mapped

I have example web application Hibernate 4.3.5 + Derby database 10.10.1.1+ Glassfish4.0 with IDE NetBeans 8.0Beta. I have the next exception: Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: CUSTOMERV is not mapped at org.hibernate.hql.internal.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.…

Read More
Cannot create JDBC driver of class ' ' for connect URL 'null' : I do not understand this exception

Why does it say null URL and gives a empty ' ' class in the exception when I have provided the database URL? I am trying to connect to a derby database via a servlet while using Tomcat. When the …

Read More
Name [jdbc/mydb] is not bound in this Context

I see this question was raised several times already and I went through all of them. But I am still unable to fix my problem. Could anyone help me pinpoint what I am doing wrong? I get the following error …

Read More