JdbcPollingChannelAdapter Streaming support

[syedyusufh]

JdbcPollingChannelAdapter used by JdbcOutboundGateway does NOT stream the resultset, whereas returns all the results as a list. This could result in OOM if there are large number of records returned.

Would be better if streaming support is added to JdbcPollingChannelAdapter used by JdbcOutboundGateway

Reference from SO:
https://stackoverflow.com/questions/74729365/spring-integration-jdbc-outboundgateway-returning-1-record-only-even-with-maxrow

[mjd507]

hello @artembilan @syedyusufh

Let me have a try on this issue 😉

Thank you!

[artembilan]

You may @mjd507 .
I have not done anything here yet because I have doubts how streaming is going to work with transactions and update functionality we have in this adapater.