Interact with the H2 Database
From the Example of my ScrumTool
https://github.com/fo0/ScrumTool
interact with the database
You can easy read the h2-database file which is default located in the same directory like your ScrumTool-VERSION.jar
To access the file you just need to download the latest h2 client from the official site: https://h2database.com/h2-2019-10-14.zip
Unzip the .zip and use the client h2-VERSION-.jar
from the bin
directory.
The command to show the tables is i.e.
java -cp h2*.jar org.h2.tools.Shell -url jdbc:h2:file:./database -user sa -password sa -sql "show tables"
To print all Boards just execute the following statement
java -cp h2*.jar org.h2.tools.Shell -url jdbc:h2:file:./database -user sa -password sa -sql "show * from tkbdata"