You would need to do some message translation from the resultset of SQL to whatever json format ES requires to use.
On Mon, Jun 15, 2015 at 2:05 PM, alexis.jacquemart <aceso...@hotmail.fr> wrote: > Thanks for you answer, > > I can't add data in the table, we have a scheduler with the last key added > in the database and we will do our updates at specific dates with this key. > This part is for later ;) > > The problem is that when I try to use a simple timer like > from("timer:foo?period=120s").to("sql:...").to("es:..."); I have the same > error from my first post.. It can't do the conversion of what he got from > the SQL query. > When I don't add the timer and begin with from("sql:"), it works great ! > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/Stop-a-SQL-route-in-Apache-Camel-tp5768252p5768261.html > Sent from the Camel - Users mailing list archive at Nabble.com. -- 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 hawtio: http://hawt.io/ fabric8: http://fabric8.io/