Uploaded image for project: 'Camel'
  1. Camel
  2. CAMEL-7382

Enable retrieving auto generated keys in JDBC component when using named parameters

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 2.14.0
    • camel-jdbc
    • Improvement is independent from environment

    • Patch Available
    • Novice

    Description

      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.

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            ggrzybek Grzegorz Grzybek
            pklink Pascal Klink
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment