SwitchYard SQL binding does not work well with update queries run on MS-SQL database

Solution Verified - Updated -


  • While using SQL Binding in reference of a SwitchYard application to UPDATE a record in MS-SQL database it seems that UPDATE does not reflect records in the database table. Also, there are no errors received in the log as well. The following is the parameterised query for quick reference.
update greetingbackup set receiver= #,sender= # where id= #;
  • Interestingly, the same code is working fine (able to see the update record) in other databases like MySQL database without any change.
  • Please note that if users use the hard-code SQL statement such as the one below then there is no issue as users could see the update in the record even in MS-SQL database.
update greetingbackup set receiver= 'Simple',sender= 'User' where id= 'I897Q';
  • How to fix this issue?


  • 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