CODEWITHSUNDEEP
corda
Ros
Ros

Reputation: 13

DB SQL for Vault in corda 3

In corda open documentation I read the following:

The ORM mapping is specified using the Java Persistence API (JPA) as annotations and is converted to database table rows by the node automatically every time a state is recorded in the node’s local vault as part of a transaction.

Presently the node includes an instance of the H2 database but any database that supports JDBC is a candidate and the node will in the future support a range of database implementations via their JDBC drivers. Much of the node internal state is also persisted there.

Can I replace h2 DB with an SQL one using JDBC?

As I understood, the FinalityFlow is used to record the transaction in the local Vault using h2 DB. If I implement a custom Flow to record in an SQL DB, i have to avoid the FinalityFlow call?

Upvotes: 1

Views: 246

Answers (1)

Joel
Joel

Reputation: 23140

Yes, it is possible to run a node with a SQL database other than H2. In fact, support for PostgreSQL and SQLServer has been contributed by the open-source community. See the set-up instructions here. However, be aware that the Corda continuous integration pipeline does not run unit tests or integration tests of these databases, so they must be used at your own risk.

Note that in both cases, you configure the node to use the alternative database via the configuration file, and it stores all its data in this alternative database (transactions, states, identities, etc.). You are not expected to access the database directly in a flow to do this, and can rely upon the standard ServiceHub operations and standard flows like FinalityFlow.

Upvotes: 2

Related Questions