Re: Need Example, use result from SQL-Query as input into Second Database/Table

Hello Claus, This was exactly what I needed Thank you so much Christian On Tue, Nov 14, 2017 at 12:05 PM, Claus Ibsen wrote: > On Tue, Nov 14, 2017 at 11:53 AM, Christian Stark > wrote: > > Thanks Claus > > > > I found the following example very helpful. > > The SQL returns multiple rows an

Re: Need Example, use result from SQL-Query as input into Second Database/Table

On Tue, Nov 14, 2017 at 11:53 AM, Christian Stark wrote: > Thanks Claus > > I found the following example very helpful. > The SQL returns multiple rows and I need to map the Columns to other > Objects. > > http://www.javarticles.com/2015/07/apache-camel-jdbc-select-example.html > > > The only thin

Re: Need Example, use result from SQL-Query as input into Second Database/Table

Thanks Claus I found the following example very helpful. The SQL returns multiple rows and I need to map the Columns to other Objects. http://www.javarticles.com/2015/07/apache-camel-jdbc-select-example.html The only thing I need to find out is how to reuse the Output of my Transformer Class as

Re: Need Example, use result from SQL-Query as input into Second Database/Table

Hi If the 1st query return only 1 row, then you can set outputType=SelectOne Then the returned value is a Map Then you can use the column names as-is in the 2nd query See the docs at https://github.com/apache/camel/blob/master/components/camel-sql/src/main/docs/sql-component.adoc On Mon, Nov 13

Need Example, use result from SQL-Query as input into Second Database/Table

Hello, Assuming the following example: I'd like to know how to control/manipulate the variables to insert the input from the first query from table/database1 into the second table/database2. What is the best option to manipulate $input1,$input2,$input3 Do we need a transformer or a converter?