Re: Camel 2.11.1, sql component returns a LinkedCaseInsensitiveMap for evry row, not a ArrayList

[Claus Ibsen]

What is the problem?

I assume you get a Map representation of the row. And a List to
contain the rows, eg List<Map>.




On Thu, Sep 5, 2013 at 2:57 PM, kalber <karlheinz.al...@swslt.com> wrote:
> 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&lt;?>> response = (List<List&lt;?>>) 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.



-- 
Claus Ibsen
-----------------
Red Hat, Inc.
Email: cib...@redhat.com
Twitter: davsclaus
Blog: http://davsclaus.com
Author of Camel in Action: http://www.manning.com/ibsen