how to build a sql insert route from xml payload

[shin938]

Hi
I created a route in servicemix that sends pax loging events to a queue and
transforms them to xml into another queue.
now i want a route that builds a sql insert from the xml payloads, but I
can't figure out the way to do that.

I think I want something like that if it was  possible:
<route>
            <from uri="activemq:logsxmlqueue"/>
            <setBody>
                    <simple>insert into log_table
values(xpath(//level),xpath(//category),xpath(//message))  </simple>
            </setBody>
            <to uri="jdbc:mysqldb"/>
 </route>

Thank you for any help.

--
View this message in context: 
http://camel.465427.n5.nabble.com/how-to-build-a-sql-insert-route-from-xml-payload-tp5528543p5528543.html
Sent from the Camel - Users mailing list archive at Nabble.com.