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 ?
Is Traccar also connected to the database? Try stopping it.
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.
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.
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 ?