jdbc connection to database, password error?

Marco 5 years ago

Oh my God, that's really stupid of me! Now I see all the tables, before I was creating a new DB. Sorry for this.
However, I can see with no problems a small, new DB file which I've just created on an empty Traccar instance. The old .mv.db file, 300+MB, gives an error
General error: "java.lang.IllegalStateException: Unable to read the page at position 134183849298104843 [1.4.200/6]" [50000-200] HY000/50000

According to https://github.com/h2database/h2database/issues/2471 it might be an issue due to different versions of h2. I'll look further into it in the next days.

Thanks, Marco

Marco 5 years ago

Solved!

All works fine by downloading
"Version 1.4.199 (2019-03-13), Last Stable"
"Platform-Independent Zip"
(https://h2database.com/h2-2019-03-13.zip)
at http://www.h2database.com/html/download.html

After unzipping the file the command is
java -jar [yourpath]/bin/h2-1.4.199.jar.

For Squirrel SQL users, copy h2-1.4.199.jar in your squirrel lib directory.

Anton, thanks a lot for your patience, and for your excellent software.

Marco