H2 database

Default database (mainly for development and testing purposes) is H2 database

There is defined Spring profile H2 for using H2 DB.

H2 database is running in embedded (local) mode with database name openHubDB by default (in-memory mode is used for unit tests only). H2 configuration is in the file application-h2.properties:

 



If there is needed to see records in in-memory database during OpenHub running then there are the following possibilities.

H2 console

H2 console is web browser based application that is configured on 8082 port.


Login page:

Select messages:

JDBC via TCP

It's possible to connect H2 OpenHub in-memory DB if H2 server is configured.

 

Login in SQuirrel: