H2 database

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

H2 database is running in embedded (local) in-memory mode with database name openHubDB.

db.driver=org.h2.Driver
db.url=jdbc:h2:mem:openHubDB
db.username=sa
db.password=

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.

configuration in sp_dataSources.xml

        <bean id="h2WebServer" class="org.h2.tools.Server" factory-method="createWebServer" init-method="start"
              destroy-method="stop">
            <constructor-arg value="-web,-webAllowOthers,-webPort,8082"/>
        </bean>

Login page:

Select messages:

JDBC via TCP

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

configuration in sp_dataSources.xml

        <bean id="h2Server" class="org.h2.tools.Server" factory-method="createTcpServer" init-method="start"
              destroy-method="stop" depends-on="h2WebServer">
            <constructor-arg value="-tcp,-tcpAllowOthers,-tcpPort,9092"/>
        </bean>

Login in Squirell: