H2 Database

H2 is a Java-based Database which replaced Derby as the default database in Payara 5. Derby as a database service that can be started and managed by Payara Server Enterprise, has been removed starting from version 5.201.

Why replace Derby?

In terms of performance, Derby is one of the slowest embedded databases as compared to other H2, PostgresSQL, HSQLDB, etc. H2 also has a smaller disk footprint; the size of a JAR file is around 1.5 MB.

To Start the Database

To start the database run the command below:

asadmin> start-database

The above command will start H2 on the default port, which is 9092.

To Stop the Database

To stop the database run the command below:

asadmin> stop-database

The above command will stop H2 by default.