I have an issue with update notification with JDBC Adapter and Microsoft SQL Server database. If I update more than 1 row in a table with one SQL statement only the 1st row updated is notified to webMethods.
I looked into the buffer table from webMethods (WMBxxxx table) and I can see that there are many rows (as many as my SQL statement updated) but all have the same WM_ROWID value. This is causing the problem.
Did anyone see this before?
Is this a bug in the way webMethods implemented the trigger or is this a feature of Microsoft SQL server.
The solution I have so far is to avoid updating multiple rows in 1 statement. If I update row by row all is ok.
I would appreciate if you have any suggestions about the real cause of this issue.