DB Feature can be use to perform database operations such as insert, update, delete and read.
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
|
