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
|