You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@camel.apache.org by "Thomas Gueze (Created) (JIRA)" <ji...@apache.org> on 2012/02/13 13:58:59 UTC
[jira] [Created] (CAMEL-5003) Add support of generated keys
retrieval in JDBC component
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
Reporter: Thomas Gueze
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
[jira] [Updated] (CAMEL-5003) Add support of generated keys
retrieval in JDBC component
Posted by "Hadrian Zbarcea (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CAMEL-5003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hadrian Zbarcea updated CAMEL-5003:
-----------------------------------
Affects Version/s: 2.9.0
Fix Version/s: 2.10.0
Thanks for the contribution. Looks good at the first glance.
> 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: Hadrian Zbarcea
> 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
[jira] [Updated] (CAMEL-5003) Add support of generated keys
retrieval in JDBC component
Posted by "Thomas Gueze (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CAMEL-5003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas Gueze updated CAMEL-5003:
--------------------------------
Attachment: support_of_generated_keys.patch
Patch resolving the issue
> 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
> Reporter: Thomas Gueze
> 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
[jira] [Work started] (CAMEL-5003) Add support of generated keys
retrieval in JDBC component
Posted by "Hadrian Zbarcea (Work started) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CAMEL-5003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on CAMEL-5003 started by Hadrian Zbarcea.
> 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
> Reporter: Thomas Gueze
> Assignee: Hadrian Zbarcea
> 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
[jira] [Resolved] (CAMEL-5003) Add support of generated keys
retrieval in JDBC component
Posted by "Claus Ibsen (Resolved) (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Assigned] (CAMEL-5003) Add support of generated keys
retrieval in JDBC component
Posted by "Hadrian Zbarcea (Assigned) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CAMEL-5003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hadrian Zbarcea reassigned CAMEL-5003:
--------------------------------------
Assignee: Hadrian Zbarcea
> 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
> Reporter: Thomas Gueze
> Assignee: Hadrian Zbarcea
> 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