How can switchyard make use of generic SQL and bound parameters?

Solution In Progress - Updated -

Environment

Red Hat JBoss Fuse 6.2.1

Issue

There is a desire to make use of arbitrary SQL (not configured at design time) and objects from the Message bound to parameters. How can this be done?

Resolution

At present, this is not possible. A Request For Enhancement (RFE) has been opened [1].

Note that use of the property 'CamelSqlQuery' allows a Reference Binding to be overridden, but it does not make a provision for bound objects. (The '#' and '?' arguments do not work.)

[1] https://issues.jboss.org/browse/ENTESB-5514

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.

Comments