Facing problem in connecting with H2 Database: 1- fireserver.log displays the error message: Database is Read Only and 2- fireserver.log displays the error message: Could not read from position…

Setup & Configuration
1

Solution to both the issues are as follows:

1- H2 DB data is stored in the file firedb.mv.

Make sure that the user with which Sparkflows is running has write access to the file.

2- Log into H2 DB and run the below:

SHUTDOWN COMPACT

Note:

H2 DB commands can be found at the this location: H2DB Commands Cheatsheet