[
https://issues.apache.org/jira/browse/CAMEL-4350?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Claus Ibsen updated CAMEL-4350:
-------------------------------
Component/s: camel-sql
camel-jdbc
Summary: Camel-jdbc with List<Map> has arbitrary column order (was:
Camel-csv with List<Map> has arbitrary column order)
Assuming its the camel-jdbc component, which is shown above.
The same issue could apply for camel-sql
> Camel-jdbc with List<Map> has arbitrary column order
> ----------------------------------------------------
>
> Key: CAMEL-4350
> URL: https://issues.apache.org/jira/browse/CAMEL-4350
> Project: Camel
> Issue Type: Improvement
> Components: camel-jdbc, camel-sql
> Affects Versions: 2.7.1
> Environment: java 1.6
> Reporter: Julian Cable
> Priority: Minor
> Fix For: 2.9.0
>
>
> The following route works but the order of the columns is dependent on the
> natural ordering of the hashmap. Target systems will have an expectation of
> the order of the data.
> <route>
> <from uri="jetty:http://0.0.0.0:16081/css/mes"/>
> <setBody>
> <constant>SELECT id, value1, value2 FROM mytable</constant>
> </setBody>
> <to uri="jdbc:mydb"/>
> <marshal>
> <csv/>
> </marshal>
> </route>
> Either there needs to be a property for csv that allows hash key ordering to
> be specified, or an option to sort the keys, e.g.
> <route>
> <from uri="jetty:http://0.0.0.0:16081/css/mes"/>
> <setBody>
> <constant>SELECT id as col1, value1 as col2, value2 as col3 FROM
> mytable</constant>
> </setBody>
> <to uri="jdbc:mydb"/>
> <marshal>
> <csv sortFields="true" />
> </marshal>
> </route>
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
