Update username & password of h2 database and restore earlier backups

452 Views Asked by At

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?

0

There are 0 best solutions below