[ https://issues.apache.org/jira/browse/CAMEL-4350?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13087203#comment-13087203 ]
Julian Cable commented on CAMEL-4350: ------------------------------------- I don't have time to try it, but it looks like changing HashMap to LinkedHashMap on lines 25 and 197 of /camel/trunk/components/camel-jdbc/src/main/java/org/apache/camel/component/jdbc/JdbcProducer.java would do the trick. Julian > 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 > 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