I have made a strange observation with an SQL update adapter that is run against Microsoft SQLServer.
We have a flow that is supposed to update a set of records in the database. Behind the SQL adapter that does this we check the return value with the number of updated rows.
But whatever the real number of rows is the adapter always returns zero. At first glance it looked like an error in the JDBC driver or somewhere else inside IS but further analysis brought to light that a database trigger listening on the table to be updated seems to influence the result. When the trigger is disabled the adapter returns the correct number of rows.
Has anyone encountered the same thing and found a solution to it?
I know that this is rather an SQLServer-specific topic but I have the hope that someone can help me here, also
When it comes to SQLServer I am a complete n00b. It was enough of a pain to “translate” the triggers from Oracle/DB2, where we created them, to SQLServer
Thanks in advance for any hints