SwitchYard SQL binding does not work well with update queries run on MS-SQL database
Issue
- While using
SQL Binding
in reference of aSwitchYard
application toUPDATE
a record inMS-SQL
database it seems thatUPDATE
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?
Environment
- 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.