When Retrieve data by executing SQL is executed on a record that has already been updated in a same transaction, the data before the update is retrieved

Question

After executing a SQL to update a specific record in a DB in a transaction, when I specify the record in the Get Data by SQL Execution, the data before the update is retrieved.
What is the cause and workaround?

Answer

-Specification
The Get Data by SQL Execution does not participate in a transaction, and it issues a query to retrieve data each time.
Therefore, the result of data retrieval depends on the transaction isolation level on the DB side.

-Cause
The cause may be that the result of the update process in the same transaction was not committed when the Get Data by SQL Execution was executed.

-Workaround
Replace the part of the Get Data by SQL Execution that retrieves data with the Execute Select SQL of an appropriate DB connector, and check whether you can retrieve the updated data.

-Reference
[Data Acquisition by SQL Execution]
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Mapper/ExecuteSelectQuery.htm