MS-SQL db update issue with FSW 6.0.0
Issue
- User is using
SQL Bindingin reference for aSwitchYardapplication toUPDATEa record inMS-SQLdatabase, but theUPDATEoperation 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>
Environment
- Red Hat JBoss Fuse Service Works (FSW)
- 6.0.0
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
