MS-SQL db update issue with FSW 6.0.0
- User is using
SQL Bindingin reference for a
UPDATEa record in
MS-SQLdatabase, but the
UPDATEoperation 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)
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.