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"