Debug School

rakesh kumar
rakesh kumar

Posted on

How to connect with h2 database in linux

Step1:Navigate to your Traccar installation directory:

cd /path/to/your/traccar
Enter fullscreen mode Exit fullscreen mode

Step2:Stop the Traccar Server

sudo systemctl stop traccar
Enter fullscreen mode Exit fullscreen mode

step3:Retry Your H2 Database Shell Command

java -cp lib/h2-2.3.232.jar org.h2.tools.Shell
Enter fullscreen mode Exit fullscreen mode 
Driver: (press Enter for default)
Enter fullscreen mode Exit fullscreen mode

URL:

jdbc:h2:./data/database
Enter fullscreen mode Exit fullscreen mode

User:

text

sa
Enter fullscreen mode Exit fullscreen mode 
Password: (leave blank)
Enter fullscreen mode Exit fullscreen mode

Success
If Traccar is stopped, you'll reach the sql> prompt and can run SQL commands:

sql

SHOW TABLES;
Enter fullscreen mode Exit fullscreen mode 
SELECT * FROM "TC_USERS";
Enter fullscreen mode Exit fullscreen mode 


java -cp lib/h2-2.3.232.jar org.h2.tools.Script -url "jdbc:h2:./data/database" -user sa -script traccar_dump.sql
Enter fullscreen mode Exit fullscreen mode

Top comments (0)