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
