Version: 17.07
Supported Since: 17.07
The Result Set Reader processing element can be used to read values from a result set which should be passed as a scope variable to this processing element. The read value from the result set will also be set as a scope variable which has a configurable name. This is a utility processing element to facilitate row lock processing for a database table and it should be used in between "Row Lock Scope Start" and "Row Lock Scope End" processors. This processing element can be configured to read any column value by providing column name and data type of the column. This supports almost all the data types which are supported in JDBC.
In order to use this processing element, you must first select the Database Operations dependency from the processor list when you are creating an empty Ultra project. If you have already created a project, you can add this dependency via Component Registry. From Tools menu, select Ultra Studio → Component Registry and from the Processors list, select the Database Operations dependency. |
Next |
Message will be forwarded to this port after setting the read value from the Result Set as a scope variable. |
On Exception |
The message context will be sent to this outport if any exception occurred while extracting the payload from the message. |
Result Set Variable Name |
Basic |
Name of the scope variable that contains the Result Set as value.
|
Variable Name * |
Basic |
Name of the variable to set the extracted value from the result set. |
Column Name * |
Basic |
Name of the column to read the value. |
Column Data Type * |
Basic |
JDBC data type of the column to be read. |
In this documentation, it’s used the same sample use case which has been used in Row Locking Processor. In this use case, the requirement is to do a database update with multiple threads by polling the database to select possible candidates for the update. A single row should be updated by a single thread to make sure the consistency of the database. Because of that it’s required to get a row lock of a row before starting process and then do required update and mark it as a processed row to make sure that it won’t be picked up for later.
In this flow a Result Set Reader processing elements is configured to read a column value and set that value as scope variable which has a configurable name.