Introduction

 

H2 database provided as an embedded persistence provider with ThingWorx. However, for those of us interested in peeking inside the structure of how the data is persisted, it's challenging to simply connect to it like other databases which are installed separately e.g. PostgreSQL, SAP Hana, or any other RDBMS connecting to ThingWorx via JDBC.

 

Disclaimer: This guide is for the purpose of debugging or view only scenarios. Any direct change to the stored data in the H2 database may lead to data corruption leading to data loss or ThingWorx failing to start.

 

How to connect to embedded H2 Database installation

 

Challenging as it may appear at first sight, connecting to H2 Database embedded with ThingWorx is quite straight forward. Here's a quick guide to it:

 

1. Download and Install H2 Database engine

 

     Visit the official page of H2Database and download the last stable version for your platform

 

2. Access the H2 Database browser

 

     Navigate to the H2 Console, for e.g. if installed on Windows OS : Window's Start > H2 Console


3. Connecting to the H2 Database embedded with ThingWorx


     H2 Console is a web based UI and will be launched in a web browser, see following sample screenshot. For connecting to the existing embedded H2 DB used within           ThingWorx, simply provide the location for the \\ThingWorxStorage\Database\ and press Connect without any username and password.


4. Exploring the H2 Console


     Once connected you will be able to view the schema and all the data stored within, like so