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.