New Stored Procedure Support

[janol]

Would it be possible to supply a stored procedure name into one of the stored procedure adapters or into a stored procedure gateway dynamically instead of pre-defining it in the configuration?

For example, would it be possible to supply it as one of the message headers or extract it from the message using SpEl?

I need to be able to run different stored procedures that have exactly the same signature and have an integer as a return value.

Thanks.

[ghillert]

Hi,

Good question. Right now you can use the default SpEL expression support provided by Spring, only.

E.g. the following expressions are valid:

... stored-procedure-name="#{new String('world').toUpperCase()} ...
... stored-procedure-name="#{@coffee.name}" ...

<bean id="coffee" class="org.springframework.integration.model.CoffeeBeverage">
    <property name="name" value="testingStoredProc"/>
</bean>

see: http://static.springsource.org/sprin...pressions.html

Thus, right now you cannot access the Spring Integration message payload/headers in order to determine the stored procedure name dynamically. If possible, could you please create a feature request in Jira and reference it back in this forum post?

Thanks for providing feedback!

Cheers,

[janol]

Thank you for your reply.

I created JIRA issue https://jira.springsource.org/browse/INT-2271