Re: Dinamyc SQL with arguments

2013-03-13 Thread Henryk Konsek
> @Chris Odom: Thanks for the suggestion, I did in this way. But I think it is > a better option support dinamyc sql query out of box in camel. Yeah, you can do almost anything with custom Bean Component, but we still should provide common and useful options in the components. -- Henryk Konsek h

Re: Dinamyc SQL with arguments

2013-03-13 Thread Gardella juan
/Dinamyc-SQL-with-arguments-tp5729003p5729089.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Dinamyc SQL with arguments

2013-03-12 Thread chris . odom
Why not just use a custom processor component to do your SQL. I usually just create the Bean as the Message body and pass it along my route. In the final Processor I just extract the Bean and use that with a DAO/SQLInvoker. These components can be setup in Spring DSL and works great, just a tho

Re: Dinamyc SQL with arguments

2013-03-12 Thread Henryk Konsek
> I'll raise Jira issue today, as in fact > we should provide support for parameters for JDBC component The issue [1] for the enhancement has been raised. [1] https://issues.apache.org/jira/browse/CAMEL-6157 -- Henryk Konsek http://henryk-konsek.blogspot.com

Dinamyc SQL with arguments

2013-03-12 Thread Gardella juan
The arguments has to be used by the jdbc driver: sqlStatement.setObject(i, arguments.get(i)) In this way I can solve SQL injection vulnerabilities. It is possible to do that with a component in camel? Best regards, Juan -- View this message in context: http://camel.465427.n5.nabble.

Re: Dinamyc SQL with arguments

2013-03-12 Thread hekonsek
nt.html [2] http://camel.apache.org/recipient-list.html -- Henryk Konsek -- View this message in context: http://camel.465427.n5.nabble.com/Dinamyc-SQL-with-arguments-tp5729003p5729006.html Sent from the Camel - Users mailing list archive at Nabble.com.