[CAMEL-5003] Add support of generated keys retrieval in JDBC component

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.9.0
• Fix Version/s: 2.10.0
• Component/s: camel-jdbc
• Patch Info: Patch Available
• Estimated Complexity: Unknown
• Assignee: Claus Ibsen
• Reporter: Thomas Gueze
• Created: 13/Feb/12 12:58
• Updated: 25/Mar/12 14:22
• Resolved: 25/Mar/12 14:22

Description

The JDBC component has no support of generated keys retrieval, i.e use of Jdbc api calls :

• statement.execute(String, int)
• [statement.execute(String, int[])|http://docs.oracle.com/javase/6/docs/api/java/sql/Statement.html#execute(java.lang.String,%20int[])]
• [statement.execute(String, String[])|http://docs.oracle.com/javase/6/docs/api/java/sql/Statement.html#execute(java.lang.String,%20java.lang.String[])]

This patch allow to retrieve the generated keys using headers :

• JDBC_RETRIEVE_GENERATED_KEYS : boolean (mandatory to retrieve the generated keys)
• JDBC_GENERATED_COLUMNS : containing the int[] or String[] generated keys expected (optional)

The results are put in two headers :

• JDBC_GENERATED_KEYS_DATA : the generated keys rows
• JDBC_GENERATED_KEYS_ROW_COUNT : the number of generated keys rows put