Add to JDBC component support for MapSqlParameterSource [INT-2395]

[spring-operator]

Artem Bilan opened INT-2395 and commented

When use jdbc:stored-proc components it will be more flexible to use +payload as Map+ of IN-procedure parameters.
And it allows to eliminate jdbc:parameter declaration.
Now we have to do it like this:

<jdbc:sql-parameter-definition name="I_PARAM1"/>
<jdbc:sql-parameter-definition name="I_PARAM2"/>
<jdbc:parameter name="I_PARAM1" expression="payload.I_PARAM1"/>
<jdbc:parameter name="I_PARAM2" expression="payload.I_PARAM2"/>

It can be simply fixed in the StaticBeanPropertySqlParameterSource:

this.input = input instanceof Map ? new MapSqlParameterSource((Map<String, Object>) input) : new BeanPropertySqlParameterSource(input);

or as exctraction an additional internal implementation of SqlParameterSource.

---

No further details from INT-2395

[spring-operator]

Artem Bilan commented

Ok, I've investigated more and found that we can do it via ExpressionEvaluatingSqlParameterSourceFactory.
Nevertheless we should define some additional bean in the context:

<int-jdbc:stored-proc-outbound-gateway request-channel="mapPayloadChannel" 
  stored-procedure-name="CREATE_USER_RETURN_ALL"
  data-source="datasource"
  id="gatewayWithEEPSF"
  sql-parameter-source-factory="sqlParameterSourceFactory"
  reply-channel="outputChannel">
  <int-jdbc:returning-resultset name="out" row-mapper="org.springframework.integration.jdbc.storedproc.UserMapper" />
</int-jdbc:stored-proc-outbound-gateway>

<bean id="sqlParameterSourceFactory" class="org.springframework.integration.jdbc.ExpressionEvaluatingSqlParameterSourceFactory"/>

Your thoughts?