Return-Path: X-Original-To: apmail-camel-issues-archive@minotaur.apache.org Delivered-To: apmail-camel-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 8A0CF11E18 for ; Mon, 21 Apr 2014 18:38:32 +0000 (UTC) Received: (qmail 85233 invoked by uid 500); 21 Apr 2014 18:38:16 -0000 Delivered-To: apmail-camel-issues-archive@camel.apache.org Received: (qmail 85078 invoked by uid 500); 21 Apr 2014 18:38:15 -0000 Mailing-List: contact issues-help@camel.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@camel.apache.org Delivered-To: mailing list issues@camel.apache.org Received: (qmail 84993 invoked by uid 99); 21 Apr 2014 18:38:15 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 21 Apr 2014 18:38:15 +0000 Date: Mon, 21 Apr 2014 18:38:14 +0000 (UTC) From: "Pascal Klink (JIRA)" To: issues@camel.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (CAMEL-7382) Enable retrieving auto generated keys in JDBC component when using named parameters MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/CAMEL-7382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pascal Klink updated CAMEL-7382: -------------------------------- Attachment: generate_keys_with_parameters.patch This is the patch for the improvement > 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 > 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)