0

The current credentials of my H2 database is very weak and I have been asked to change it to a complex one. There are so many backups (*.db files) which are already created with my old credentials. When I try to retrieve the backups with new credentials in my Java application, I get error as ,

org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException: Wrong user name or password [28000-200]

When I put back my old credentials, everything works fine. What are the possible ways that I could read the backups, created with my old credentials ?

I already referred a similar question here : how to reslove wrong username and password error in h2 database and springboot?

learner
  • 39
  • 3
  • Look to this one: https://stackoverflow.com/questions/53908887/how-to-change-h2-db-password – Daniel Zin Nov 29 '21 at 21:27
  • @Daniel : The link has only the normal SQL command to update the password(also looks remaining steps are for WSO). My case is that the existing H2 DB password is replaced in Java application and I want to read the h2 backups created with old credentials. – learner Nov 29 '21 at 21:46
  • I mean , I just need to update the weak password of H2 Database to a strong password in my Java application – learner Nov 29 '21 at 21:52
  • Please refer to my answer here stackoverflow.com/a/74924258/398348 – likejudo Dec 26 '22 at 22:04

0 Answers0