I am trying to configure SQL database JDBC adapter service to achieve query as mentioned below.
SET Status = ‘1’
WHERE ItemName in ( ? )
number of elements in IN statement can go up to 500 elements like " IN(241564,241570,241571)"
Error Screenshot from toolkit is attached for reference.
I am using Custom JDBC Adapter service, which works fine when only value (Ex : 241564) which results in query executed as “UPDATE StagedData SET Status = ‘1’ WHERE ItemName in (241564)” and result in success.
Any help in this regard will be highly helpful.
Kumar Shanmugam J