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