On Tue, Jan 24, 2012 at 7:53 PM, pvenini <pven...@mervaros.com.ar> wrote: > Hi, I'm developing a info distribution system that gets an XML document with > data entries and then has to enrich it with nodes that are obtained from a > SQL database. The SQL query has to be generated using paramethers from data > inside the original XML document (they are properties of some of the nodes). > I was thinking about using the enrich statement but I don't realize how can > I generate the dynamic query (using sql: or jdbc:) without loosing the > original XML document. >
Often a Java bean is a good idea to access a JDBC data source. Then you can construct the query, execute and get the result back, and merge in a result as you want. And from the Java bean you can use a ProducerTemplate for example if you want to send a message to a Camel endpoint, and get back a message. > Thanks > > Pablo > > -- > View this message in context: > http://camel.465427.n5.nabble.com/Enrich-message-with-data-from-dynamic-sql-query-tp5329427p5329427.html > Sent from the Camel - Users mailing list archive at Nabble.com. -- Claus Ibsen ----------------- FuseSource Email: cib...@fusesource.com Web: http://fusesource.com Twitter: davsclaus, fusenews Blog: http://davsclaus.blogspot.com/ Author of Camel in Action: http://www.manning.com/ibsen/
