JDBC ResultSet to Java Object/XML

[vishvjit]

Hello,

Is there a complete example for processing JDBC select resultset & converting each row to Java Object/XML ? I have tried following options without success -

1. <to uri="jdbc:myDS?outputClass=com.sample.Customer" /> where com.sample.Customer has variables matching resultset column names with setter methods.

2. <to uri="jdbc:myDS?outputClass=com.sample.CustomerList" /> where com.sample.CustomerList has private List<Customer> custList

3. Result to xmlstream.

Nothing works and the in split pattern BodyType remains java.util.LinkedHashMap. Pls share your views.

[davsclaus]

Ah wonder if mapping to class is only supported when outputType=SelectOne.

[davsclaus]

Checked the source code and its only supported currently for 1 row.

Logged a ticket to improve this: https://issues.apache.org/jira/browse/CAMEL-7645

[vishvjit]

Thanks Claus.

Can you pls suggest any alternative to convert List of rows returned from JDBC component to objects or XML ?

[davsclaus]

Just mind that CAMEL-7645 has been implemented and will be part of Camel 2.14 which is intended to be included in JBoss Fuse 6.2.

As an alternative you can write some java code that does the list -> object/xml conversion.

There is also other kind of sql components with Apache Camel such as camel-mybatis that is stronger.

http://camel.apache.org/mybatis