You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@camel.apache.org by snurmine <gi...@git.apache.org> on 2016/01/01 22:31:37 UTC

[GitHub] camel pull request: CAMEL-4725 camel-sql - Add support for Callabl...

GitHub user snurmine opened a pull request:

    https://github.com/apache/camel/pull/749

    CAMEL-4725 camel-sql - Add support for Callable statements

    Here is demo of how calling stored procedure could work. I call them Simple Stored Procedure Templates. Current solution is just a proof-of-concept and has style, bugs, missing features etc. issues. I provide this PR just for discussion.
    
    Idea is that instead of SQL-query, a simple template is used to describe stored procedure. From parsed template, subclass of org.springframework.jdbc.object.StoredProcedure can then be constructed by information given in the template. For example
    
    ```javascript
    sql:sspt:ADDNUMBERS(INTEGER VALUE1 ${headers.num1},INTEGER VALUE2 ${headers"
                            + ".num2},OUT INTEGER RESULT resultofsum)
    ```
    
    Here Producer would call ADDNUMBERS stored procedure using parameters VALUE1 and VALUE2.
    Values are fetched from headers "num1" and "num2". Output (INTEGER) is stored into header "resultofsum". Here INTEGER refers to java.sql.Types field INTEGER. Parameter order seems to be meaningfull, but names a still given.
    
    
    Test org.apache.camel.component.sql.sspt.ProducerTest shows how template is used in Procuder.
    
    I can polish solution further if this approach seems okey.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/snurmine/camel CAMEL-4725

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/camel/pull/749.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #749
    
----
commit 281a10a22436a679f2f51c57a2175cdf6535f65f
Author: Sami Nurminen <sn...@gmail.com>
Date:   2015-12-20T21:34:33Z

    CAMEL-4725 camel-sql - Add support for Callable statements

----


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] camel pull request: CAMEL-4725 camel-sql - Add support for Callabl...

Posted by snurmine <gi...@git.apache.org>.
Github user snurmine closed the pull request at:

    https://github.com/apache/camel/pull/749


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---