HSQLDB is an open source relational database attached as a standard to Wagby. It is implemented in the Java language, it is characterized by its light weight and high speed. Here are points to note when using HSQLDB.
HSQLDB is shipped as a simple database for use during development.It is deprecated to use it in production applications.
All types are treated as Java internal mechanisms (basic types such as int, float and standard classes such as java.lang.String).
Automatically start and stop the database at the timing of Tomcat start/stop.
The body (program) of hsqldb is $ (DEVHOME) \ env \ lib-common \ hsqldb.jar.After the build, it is placed in wagbyapp \ lib \ hsqldb.jar.This program also serves as a JDBC driver.
The physical file of the database is wagbyapp \ webapps \ $ (APPNAME) \ WEB - INF \ data \ $ (APPNAME) db.script.The standard is wagbydb.script.
The file is in text format.You can check the contents with a text editor.
When backing up a physical file, please save both the .script and the .properties file on the same folder.