Loading...

XML

Word

Printable

Fuse Progress Bar:

% %
Workaround Description:
- Set resolved nested simple expression once in a message header or property. And use it from camel-sql.
Git Pull Request:
https://github.com/jboss-fuse/camel/pull/693

camel-sql cannot resolve nested simple expression
For example, `to("sql:insert into T_EXAMPLE values (:#${header.header1[${header.CamelLoopIndex}][COLUMN_NAME1]})")` is resolved as `insert into T_EXAMPLE values (?][COLUMN_NAME1]})` instead of `insert into T_EXAMPLE values ( ? )}`. And database driver will generate a syntax error.
FYI, `.setHeader("header1",simple("${header.header1[${header.CamelLoopIndex}][COLUMN_NAME1]})"))` is resolved correctly. So probably sql-camel cannot properly parse the range of simple expression.

links to

CAMEL-13305