db feature

DB Feature

Version: 17.07

Supported Since: 17.01

DB Feature

DB Feature can be use to perform database operations such as insert, update, delete and read.

APIs Java Docs

update

Parameters
DataSource datasource

Datasource instance which can be used to perform database operation

File mappingFile

JSON configuration mapping file which can be used to decipher parameterized SQL statement

String ParameterizedSQL

Parameterized SQL statement

XMessageContext xMessageContext

Message Context with required payload which can be used to perform database operation

Returns
int

The number of data rows affected

This API can be used to perform database insert, update and delete operations

read

Parameters
DataSource datasource

Datasource instance which can be used to perform database operation

File mappingFile

JSON configuration mapping file which can be used to decipher parameterized SQL statement

String ParameterizedSQL

Parameterized SQL statement

XMessageContext xMessageContext

Message Context with required payload which can be used to perform database operation

Returns
List<Map<String, Object>>

Where each item of the list represent a row of the query result, and for each row, the map contains the table column name as the key and its respective value as the value.

This API can be used to perform database read operations

In this topic
In this topic
Contact Us