Skip to Content
0
Aug 02, 2016 at 03:47 PM

JDBC Sender Update on primary key

218 Views

Hi,

i have a JDBC Sender to XI-Message scenario.

By default JDBC Sender uses a Query Statement and an Update Statement to process data.

see the SAP example:

SELECT * FROM table WHERE processed = 0;

UPDATE table SET processed = 1 WHERE processed = 0;

In my Scenario I want to update each dataset by it's own primary key.

this means

SELECT * FROM table WHERE processed = 0;

the result is a dataset of 5 rows.

now i want to call 5 update commands.

UPDATE table SET processed = 1 WHERE primarykey = row[1].primarykey;

UPDATE table SET processed = 1 WHERE primarykey = row[2].primarykey;

UPDATE table SET processed = 1 WHERE primarykey = row[3].primarykey;

UPDATE table SET processed = 1 WHERE primarykey = row[4].primarykey;

UPDATE table SET processed = 1 WHERE primarykey = row[5].primarykey;

is there any possibility to do that in die JDBC-Sender adapter?

if the possibility is a module, how can i access the JDBC-Sender channel to get a jdbc connection?

thanks a lot.