MS-SQL db update issue with FSW 6.0.0

Issue

• User is using SQL Binding in reference for a SwitchYard application to UPDATE a record in MS-SQL database, but the UPDATE operation does not seem to reflect in the database table. Also, there are no errors received in the log as well. The following is the parameterised query which is being used in reference binding.

<sql:query>update greetingbackup set receiver= #,sender= # where id= #;</sql:query>

Interestingly, the same code is working fine (able to see the updated record) in other databases like MySQL database without any change. What is the root cause behind this issue and how to fix it?

• Please note that if user uses the hard-code SQL statement such as the one below then there is no issue as the update operation works fine.

<sql:query>update greetingbackup set receiver= 'TestReceiver',sender= 'TestSender' where id= '10';</sql:query>