You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@camel.apache.org by "Claus Ibsen (Resolved) (JIRA)" <ji...@apache.org> on 2012/03/25 16:23:26 UTC
[jira] [Resolved] (CAMEL-5003) Add support of generated keys
retrieval in JDBC component
[ https://issues.apache.org/jira/browse/CAMEL-5003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Claus Ibsen resolved CAMEL-5003.
--------------------------------
Resolution: Fixed
Assignee: Claus Ibsen (was: Hadrian Zbarcea)
Thomas, thanks for the patch.
I have applied it, as well updated documentation.
> Add support of generated keys retrieval in JDBC component
> ---------------------------------------------------------
>
> Key: CAMEL-5003
> URL: https://issues.apache.org/jira/browse/CAMEL-5003
> Project: Camel
> Issue Type: Improvement
> Components: camel-jdbc
> Affects Versions: 2.9.0
> Reporter: Thomas Gueze
> Assignee: Claus Ibsen
> Fix For: 2.10.0
>
> Attachments: support_of_generated_keys.patch
>
>
> The JDBC component has no support of generated keys retrieval, i.e use of Jdbc api calls :
> - [statement.execute(String, int)|http://docs.oracle.com/javase/6/docs/api/java/sql/Statement.html#execute(java.lang.String,%20int)]
> - [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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira