How to convert a SQL result in a XML document ?

[jklemm]

How to convert a SQL result in a XML document with Camel ?

I don't found any conversor to solve my problem.

Simple Code Example:

from("direct:SQL_EXEC")

.process(new Processor(){

public void process(Exchange exchange) throws Exception {

List<String> params = new ArrayList<String>();

params.add("ABCDEFG");

exchange.getOut().setBody(params, List.class);

}})

.to("sql:SELECT * FROM SCHEMA.TABLE WHERE COLUMN = #")

.TRANSFORM_RESULT_LIST_TO_XML()

.to("direct:sendXML");

Thanks.

[janstey]

You can use the XStream component to achieve this.

from("direct:SQL_EXEC").process(new Processor() {
    public void process(Exchange exchange) throws Exception {
        List<String> params = new ArrayList<String>();
        params.add("ABCDEFG");
        exchange.getOut().setBody(params, List.class);
    }
}).to("sql:SELECT * FROM SCHEMA.TABLE WHERE COLUMN = #").
marshal().xstream().to("direct:sendXML");

Just make sure that camel-xstream-*.jar is on the classpath.

Cheers,

Jon

[anielson]

You can use XBeans, Xstream or JAXB. See the documentation at: http://fusesource.com/docs/esb/4.0/fmr_nmr/FMRS.TMC.html#FMRS.MU