Announcement Announcement Module
Collapse
No announcement yet.
New Stored Procedure Support Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • New Stored Procedure Support

    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.

  • #2
    Hi,

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

    E.g. the following expressions are valid:

    Code:
    ... 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,

    Comment


    • #3
      Thank you for your reply.

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

      Comment

      Working...
      X