I configured this route : from("sql:select obj_code, prv_targa, stc_pccode, prv_prodtela, prv_modtela, prv_tipobus from cust_positions where obj_org in ('ICT') and obj_class in ('BUS') order by prv_concessi?dataSource=#dataSource.infor&noop=true") .process(new ExportFileConvert());
in the ExportFileConvert i recive for evry row and LinkedCaseInsensitiveMap not how i excpected once an ArrayList of LinkedCaseInsensitiveMap; How can configure the route to recive an ArrayList<LinkedCaseInsensitiveMap> ? NB: Using a template with the direct component it works, here the code ; public void configure() throws Exception { from("direct:busmsg.select.sms_bus") .to("sql:SELECT tipo_msg, from_unixtime(rcv_time) rcv_time, from_unixtime(event_time) event_time, codazi, matr_bus, linea, corsa, palina, anticipo, ritardo FROM busmsg.sms_bus_# where date_format(from_unixtime(event_time), '%Y-%m-%d %H') > # and date_format(from_unixtime(event_time), '%Y-%m-%d %H') <= # order by from_unixtime(rcv_time)?dataSource=#dataSource.busmsg") .bean(new BusmsgConvert(), "convertMap2List"); } ProducerTemplate template = camelWrapper.createProducerTemplate(); List<List<?>> response = (List<List<?>>) template.requestBody( "direct:busmsg.select.sms_bus", new Object[] { processConfig.composeStartElabDate(), processConfig.composeEndElabDate() }); ----- kh -- View this message in context: http://camel.465427.n5.nabble.com/Camel-2-11-1-sql-component-returns-a-LinkedCaseInsensitiveMap-for-evry-row-not-a-ArrayList-tp5738761.html Sent from the Camel - Users mailing list archive at Nabble.com.