[jira] [Commented] (CAMEL-7382) Enable retrieving auto generated keys in JDBC component when using named parameters

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CAMEL-7382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13976646#comment-13976646 ] 

ASF GitHub Bot commented on CAMEL-7382:
---------------------------------------

GitHub user grgrzybek opened a pull request:

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

    [CAMEL-7382] Retrievie auto generated keys in camel-jdbc with named params

    Thanks Pascal Klink for the patch!

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

    $ git pull https://github.com/grgrzybek/camel CAMEL-7382

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

    https://github.com/apache/camel/pull/138.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 #138
    
----
commit 22f23e06ce8c9ebe4755ed36d2616f0cdec026df
Author: Grzegorz Grzybek <gr...@gmail.com>
Date:   2014-04-22T11:16:26Z

    [CAMEL-7382] Enable retrieving auto generated keys in JDBC component when using named parameters
    
    Thanks Pascal Klink for the patch!

----


> Enable retrieving auto generated keys in JDBC component when using named parameters
> -----------------------------------------------------------------------------------
>
>                 Key: CAMEL-7382
>                 URL: https://issues.apache.org/jira/browse/CAMEL-7382
>             Project: Camel
>          Issue Type: Improvement
>          Components: camel-jdbc
>         Environment: Improvement is independent from environment
>            Reporter: Pascal Klink
>            Assignee: Grzegorz Grzybek
>              Labels: patch
>         Attachments: generate_keys_with_parameters.patch
>
>
> The JDBC component is currently not capable of retrieving auto generated keys when using named parameters. I think support for this should be added since it is no effort to implement (the most changes in the patch are related to the test classes) and enables safe insertion into tables with auto generated keys since prepared statements are used when the query is filled with named parameters.
> One thing to note is that I could not run the JdbcSpringAnotherRouteTest because there was an error when instantiating the CamelNameSpaceHandler because of a NoClassDefFoundError for org/apache/camel/core/xml/AbstractCamelEndpointFactoryBean. I think this is because I did not select the correct maven profile. So run this test after applying the patch to be sure everything works fine.



--
This message was sent by Atlassian JIRA
(v6.2#6252)