Re: Using named query parameters

2015-01-15 Thread Ettoregia
Hi There, in my case works but I had to escape the : and #, see the example below INSERT INTO "ORDER" (name, status, \"processID\") VALUES(\:\#name, \:\#status, \:\#processID) -- View this message in context: http://camel.465427.n5.nabble.com/Using-named-query-parameters-tp5758002p5761770.htm

Re: Using named query parameters

2014-10-29 Thread Henryk Konsek
Hi, > I'm still not sure if the way I'm trying to access the java.util.Map > resultset with :#Position is the right way. It seems that nobody is using > this feature at all (at least I cannot find any other samples on the > internet). If it is documented, then it is supposed to work. :) If you ca

Re: Using named query parameters

2014-10-27 Thread Router
Hi Claus, I'm still not sure if the way I'm trying to access the java.util.Map resultset with :#Position is the right way. It seems that nobody is using this feature at all (at least I cannot find any other samples on the internet). -- View this message in context: http://camel.465427.n5.nabb

Re: Using named query parameters

2014-10-27 Thread Claus Ibsen
Hi Yeah sounds like we should validate in camel that the key exists. You are welcome to log a JIRA ticket http://camel.apache.org/support On Mon, Oct 27, 2014 at 11:46 AM, Router wrote: > Is it a bug? > > Under http://camel.apache.org/sql-example.html at the very bottom it says: > > Notice in

Re: Using named query parameters

2014-10-27 Thread Router
Is it a bug? Under http://camel.apache.org/sql-example.html at the very bottom it says: Notice in the SQL queries below we use named parameters which must start with prefix ':#' and then the name, eg :#amount. Then Camel will bind that parameter with the given name, from the message body (if its