The executeUpdate method must not return a result set.
I am trying to import a csv file into MS SQL. I have a setup the mapping and I am able to insert records successfully. However if the record exists I get the error. The executeUpdate method must not return a result set. In the tMap I am importing the primary key as well and the schema of output table has the primary key defined. In the DBOutput I have specified the Action on data to Insert or update. I am assuming this handles the decision to insert or update based on the primary key being present in the table or not. Is this correct?
Re: The executeUpdate method must not return a result set.
Hi Sabrina, There are 4 triggers on the table and one of the AFTER UPDATE trigger seems to cause the exception. If I disable that trigger then I do not get this error. There is another AFTER UPDATE trigger that does not cause an issue. I will need to investigate the culprit trigger do find out where the issue arises. Thanks.