H2 database manipulation says "The database is read only"

FunkFlex4 years ago

Hi everyone,

I am running Traccar on a Windows machine and I wanted to delete some positions entry in the database. I downloaded the h2database tools and succesfully connected to the database file. But everytime I want to send a SQL command, the tool says the following:
org.h2.jdbc.JdbcSQLNonTransientException: The database is read only;
The Traccar service is running as the local system account, I start the h2w.bat as an administrator.

Could somebody point me in the right direction ?

Anton Tananaev4 years ago

Is Traccar also connected to the database? Try stopping it.

FunkFlex4 years ago

I dont think so. If I want to open the database when Traccar is running it throws an error.
I stopped the Traccar service and opended the database.

FunkFlex3 years ago

Ok, I found the problem a long time ago and wanted to update.

The Traccar installation was under "C:\Program files (x86)*" and of course, the database tool needs admin privileges to access that file.

So, start it with elevated rights and everything works now.