Re: camel-sql Query with params list
Hey claus! This feature is included into 2.17.0? /SQL component can now load the SQL queries from external resources so you can use comments and format the queries using multi lines and indents. In addition to that the SQL component now supports SQL IN queries where the IN values are dynamic calculated from the message body. And there is also support for calling stored procedures using the sqlstored component. / ( http://www.davsclaus.com/2016/03/apache-camel-217-released.html ) -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-Query-with-params-list-tp5778544p5780265.html Sent from the Camel - Users mailing list archive at Nabble.com.
Re: camel-sql Query with params list
I expected your answer. Claus give me some clues. I try to develop it, and then I'll send -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-Query-with-params-list-tp5778544p5778582.html Sent from the Camel - Users mailing list archive at Nabble.com.
Re: camel-sql Query with params list
Hi Yeah IN is not supported. Wonder what a good syntax for that would look like, as you would need to differentiate the values should be enclosed in quotes or not, eg strings vs numbers etc. We have also previously talked about being able to specify the SQL type to use for the parameters. So if we can come up with a good syntax for that we can maybe add the IN stuff too. That said there is other SQL components in camel that support this like MyBatis, or potentially ElSql etc. On Thu, Mar 3, 2016 at 1:38 PM, fabrizio.spataro wrote: > hello, > > i would execute this query: > > /> > > But i am thinking it is not supported yet. > > How to do it? > > Tnkx, fabrizio > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/camel-sql-Query-with-params-list-tp5778544.html > Sent from the Camel - Users mailing list archive at Nabble.com. -- Claus Ibsen - http://davsclaus.com @davsclaus Camel in Action 2: https://www.manning.com/ibsen2