Mailing-List: contact users-help@camel.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@camel.apache.org
MIME-Version: 1.0
In-Reply-To: <1450860845032-5775389.post@n5.nabble.com>
References: <1450860611333-5775388.post@n5.nabble.com>
 <1450860845032-5775389.post@n5.nabble.com>
From: Alessandro Rontani <fullmetaljohns@gmail.com>
Date: Sun, 27 Dec 2015 22:40:45 +0100
Message-ID: 
 <CAONTjFSWkrTO_KLZLgMzd6UxPSfu0rksxfOQQ62XRma3uXGEGg@mail.gmail.com>
Subject: Re: Unable to resolve named parameter in camel route
To: users@camel.apache.org
Content-Type: multipart/alternative; boundary=001a113f67eea792510527e80b2d

--001a113f67eea792510527e80b2d
Content-Type: text/plain; charset=UTF-8

Your problem is that the parameters *numbersubscribers* and and *id* must
be present as headers in the message: when your message reach the jdbc
component the body of the message contains the query, but cannot find the
parameters.

Doing something like this can solve your problem:

from("timer://foo?period="+serverData.getTimer())
.threads(serverData.getNumberOfInstances())
.setBody(constant(serverData.getSql())).to("jdbc:"+ serverData.getUrl() +
serverData.getUserId())
*.setHeader("id",simple("${body[0][id]}"))*
*.setHeader("numbersubscribers",simple("${body[0][numbersubscribers]}"))*
.setBody(constant("insert into new_raw_table_test (numbersubscribers, id)
values(:?numbersubscribers,:?id)"))
.to("jdbc:" + serverData.getUrl() +
serverData.getUserId()+"?allowNamedParameters=true&outputType=SelectOne&useHeadersAsParameters=true&resetAutoCommit=false")
.process(custom application logic);

your first query on JDBC component returns a list (representing the db rows
returned), and every element of the list is a map with the column name as
key and the value in the row as value. The code in bold above put into the
headers the values retrieved from the body. The solution suggested works if
the first DB call returns at least a row, if there is no result probably it
will raise an ArrayOutOfBound exception

I hope that the syntax that i have used is correct (i use always the XML
notation, not the Java one ^_^ )

Best Regards
Alessandro Rontani
-- 
*Siamo quello che facciamo ripetutamente. L'eccellenza non e' un atto, ma
abitudine - *Aristotele

2015-12-23 9:54 GMT+01:00 ghoshp29 <pralay.ghosh@gmail.com>:

> One typo in the camel route syntax. Correct syntax used in application is
> below -
>
>
> from("timer://foo?period="+serverData.getTimer()).threads(serverData.getNumberOfInstances()).setBody(constant(serverData.getSql())).to("jdbc:"
> + serverData.getUrl() + serverData.getUserId()).setBody(constant("insert
> into new_raw_table_test (numbersubscribers, id) values(:?numbersubscribers,
> :?id)")).
> to("jdbc:" + serverData.getUrl() +
>
> serverData.getUserId()+"?allowNamedParameters=true&outputType=SelectOne&useHeadersAsParameters=true&resetAutoCommit=false").process(custom
> application logic);
>
>
>
>
>
> --
> View this message in context:
> http://camel.465427.n5.nabble.com/Unable-to-resolve-named-parameter-in-camel-route-tp5775388p5775389.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>

--001a113f67eea792510527e80b2d--