On Mon, Dec 27, 2010 at 7:59 AM, Tommy Chheng <[email protected]> wrote:
> Is it possible to use jdbc's prepared statements with camel-jdbc?
> It's more for a matter of preventing sql injection than performance.
>
No its not possible.
However if you want to help improve camel-jdbc feel free to work on a
patch to support prepared statements.
You can use Spring JdbcTemplate which supports prepared statements.
>
> My route is using a bean to transform an xml data input into a insert
> statement like this:
> from("direct:xmlInput").
> bean(classOf[xmlTransformToSql]).
> log("Received: ${body}").
> to("jdbc:test_data")
>
>
> I'm escaping the input in the bean but a prepared statement would be more
> secure.
>
>
>
> --
> @tommychheng
> http://tommy.chheng.com
>
>
>
--
Claus Ibsen
-----------------
FuseSource
Email: [email protected]
Web: http://fusesource.com
Twitter: davsclaus
Blog: http://davsclaus.blogspot.com/
Author of Camel in Action: http://www.manning.com/ibsen/
