JDBC Sender Update on primary key

[ChRa]

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.

[turmoll · Accepted solution]

Have you considered to write stored procedure? Not sure which DB you use since there are some constraints. Look at:

Regards,

Jakub