MS-SQL db update issue with FSW 6.0.0

Solution Unverified - Updated -


  • 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>


  • Red Hat JBoss Fuse Service Works (FSW)
    • 6.0.0

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content