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

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.14.0
• Component/s: camel-jdbc
• Labels: patch

Environment

Improvement is independent from environment

• Patch Info: Patch Available
• Estimated Complexity: Novice
• Assignee: Grzegorz Grzybek
• Reporter: Pascal Klink
• Created: 21/Apr/14 18:35
• Updated: 08/Jun/14 12:59
• Resolved: 24/Apr/14 06:44

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.