Hi !
I have a jdbc receiver scenario. Testing it via client http adapter in BE QoS, when trying to send an UPDATE_INSERT action type message, with only 1 record data, using a new primary key value that works correctly from the SQL console (I use a new PK data each test), the record does not get inserted. I'm using 1 access node and 1 key node. (If I try to update a previously existent record, it gets updated correctly)
I receive:
<update_count>-1</update_count>
<insert_count>0</insert_count>
with the update count as negative !!!!
If I use the same target XML message, with @action=UPDATE, it returns:
<update_count>-1</update_count>
If I use the same target XML message, with @action=INSERT, it returns:
<insert_count>1</insert_count>
and it works !!!! , but I need an update_insert action to avoid a previous lookup to determine if I have to update or insert.
What am I doing wrong?
Regards,
Matias.