jdbc connection to database, password error?

Marco5 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

Marco5 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