How do I set the schema when using StoredProcPollingChannelAdapter? I do have 2 to 3 schemas on the same database connection object and the traditional "schema"."stored_proc" reference does not seem to work when using StoredProcPollingChannelAdapter
I two words this is not supported as clean as possible at the moment. We have an old JIRA ticket to see what and how is possible: https://jira.spring.io/browse/INT-3348.
As a workaround I would suggest to go directly with the SimpleJdbcCall wrapped into some MessageSource instead of that StoredProcPollingChannelAdapter.