Camel-csv with List<Map> has arbitrary column order
---------------------------------------------------

                 Key: CAMEL-4350
                 URL: https://issues.apache.org/jira/browse/CAMEL-4350
             Project: Camel
          Issue Type: Improvement
    Affects Versions: 2.7.1
         Environment: java 1.6
            Reporter: Julian Cable


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

        

Reply via email to