I logged a ticket https://issues.apache.org/jira/browse/CAMEL-7313
On Wed, Mar 19, 2014 at 11:18 AM, Claus Ibsen <claus.ib...@gmail.com> wrote: > Hi > > Don't think we support returning generated keys in camel-sql. Feel > free to log a JIRA ticket > > > On Tue, Mar 18, 2014 at 10:00 PM, Matt Payne <pa...@mattpayne.org> wrote: >> Greetings! Would you please help me find an example of using the SQL[1] >> component and inserting into a table where the primary key is automatically >> generated? This is documented as possible with the JDBC component[2,3]: >> >> "If you insert data using SQL INSERT, then the RDBMS may support auto >> generated keys. You can instruct the >> JDBC<http://camel.apache.org/jdbc.html> producer >> to return the generated keys in headers. >> To do that set the header CamelRetrieveGeneratedKeys=true. Then the >> generated keys will be provided as headers with the keys listed in the >> table above." >> >> I am using SQL[1] component rather than JDBC[2] component because the SQL >> component works with transactions. >> >> Would you please help me find an example of using the SQL[1] component and >> inserting into a table where the primary key is automatically generated? >> >> Thanks! --Matt Payne >> >> [1] http://camel.apache.org/sql-component.html >> [2] http://camel.apache.org/jdbc.html >> [3] >> https://svn.apache.org/repos/asf/camel/trunk/components/camel-jdbc/src/test/java/org/apache/camel/component/jdbc/JdbcGeneratedKeysTest.java > > > > -- > Claus Ibsen > ----------------- > Red Hat, Inc. > Email: cib...@redhat.com > Twitter: davsclaus > Blog: http://davsclaus.com > Author of Camel in Action: http://www.manning.com/ibsen > Make your Camel applications look hawt, try: http://hawt.io -- Claus Ibsen ----------------- Red Hat, Inc. Email: cib...@redhat.com Twitter: davsclaus Blog: http://davsclaus.com Author of Camel in Action: http://www.manning.com/ibsen Make your Camel applications look hawt, try: http://hawt.io
