View Corda tables in H2 Database

Ashok JKannan
Apr 22, 2019 · 2 min read
Image result for corda h2

By default, Corda store their data in an H2 database.

The database (a file called persistence.mv.db) is created when the node first starts up.

Let’s take an example — https://github.com/corda/LetterOfCredit

We are not going to talk about the CORDA implementation here, we are going to see how the data has been stored by default.

LetterOfCredit application has few modules

Image for post
Image for post

Let’s take the Notary Pool and see how the data are in H2 (by default)

By default, it has an administrator user saand a blank password. The database password is required only when the H2 database is exposed on non-localhost address (which is disabled by default).

Lets say the application is deployed and is running in the portal.

Image for post
Image for post

Connecting using the H2 Console

  • Download the last stable h2 platform-independent zip, unzip the zip, and navigate in a terminal window to the unzipped folder

Identify the persistence.mv.db file,

Image for post
Image for post

The command to start the H2 console,

java -jar h2–1.4.197.jar -webAllowOthers -tcpAllowOthers

Image for post
Image for post

Use the jdbc URL,

jdbc:h2:file:/home/corda/LetterOfCredit/kotlin-source/build/libs/build/20190416–114935.603/NotaryPool/persistence.mv.db

Image for post
Image for post

Once connected, the tables can be viewed,

Image for post
Image for post

That’s it.. Lets rock Blockchain Database guys!!!

Next article we can see about Nodes configured to use PostgreSQL.

beovolytics

Beovolytics integrates software assembly lines into large…

Medium is an open platform where 170 million readers come to find insightful and dynamic thinking. Here, expert and undiscovered voices alike dive into the heart of any topic and bring new ideas to the surface. Learn more

Follow the writers, publications, and topics that matter to you, and you’ll see them on your homepage and in your inbox. Explore

If you have a story to tell, knowledge to share, or a perspective to offer — welcome home. It’s easy and free to post your thinking on any topic. Write on Medium

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store