Skip to Content
0
Former Member
Dec 04, 2008 at 02:40 PM

UPDATE_INSERT only updates, does not inserts

33 Views

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.