Page Comparison

...

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

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

...

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

H2 console

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

        <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:

Image RemovedImage Added

Select messages:

Image RemovedImage Added

JDBC via TCP

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

        <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:

Image RemovedImage Added