DB Connector

allows to perform operations such as querying, inserting, updating, and deleting data in the database

Supporting databases

  • PostrgreSQL

Connector settings

  • Name - refers to the unique identifier. (must consist of letters (A-Z or a-z), digits (0-9), underscores (_), or dollar signs ($). However, a class name cannot start with a digit and dollar sign ($))

  • Database type - defines type of database to connect

  • URL - address of the database to connect.

  • User - username

  • Password - password

All settings should be defined as global variables. This enables the redefinition of values for new deployments.

Global variables allow the definition of different values for development, test, pre-production, and production environments.

URL

URL is a string that depends on type of database to connect with.

URL structure:

jdbc:db_type://server:port/db_name?currentSchema=schema_name

  • jdbc - system uses Java drivers to connect to databases. Don't modify this prefix

  • db_type - database type

  • server - database server address

  • port - server port

  • db_name - database name

  • schema_name - (OPTIONAL) define schema to restrict access inside query builders

Example:

jdbc:postgresql://dbpublic.cloud.processmix.com:5455/ewallet?currentSchema=public

Queries

There are two types of queries:

  1. Prepared - SQL should be defined during the design phase.

  2. Dynamic - SQL should be defined at runtime.

Transactions

A transaction is a set of operations for working with a database (DB), combined into one atomic bundle. It is used when it is important to perform a set of actions altogether, if each separate action does not make any sense without the others, or if the data in different places must be in a consistent state. If at least one operation from the transaction fails as an error or exception, the system cancels each transaction operation included.

Find more information on the nodes' respective pages:

PreviousEVM Blockchain ConnectorNextPrepared query

Last updated