How to send array as a single payload to a jdbc : outbound gateway of Spring Integration ? I am constructing an array of string and sending it to the interface method . However the SQL accepts one parameter ":payload" and it fails with UncategorizedSQLException.
The Sql query of outbound gateway is as below
<int-jdbc:outbound-gateway data-source="dataSource" request-channel="requestChannel"
query="select XMLMSG from Table where SEQ_ID in (:payload)"
reply-channel="replyChannel" >
</int-jdbc:outbound-gateway>
serviceinterface.findBySequenceIds(sequenceIdStringArray);