Re: Possibility of jdbc component when performing a select to return a map

[angelo.rlcosta]

Hello Antoine,

Your solution worked perfectly. Thanks alot!

Cheers


Ângelo Costa

On Mon, Mar 16, 2015 at 5:50 PM, Antoine DESSAIGNE [via Camel] <
ml-node+s465427n5764229...@n5.nabble.com> wrote:

> Hi,
>
> No, it's not possible. In order to be unique in your Map it has to know
> which fields are part of key (assuming that you retrieve them all).
>
> If you have camel-groovy in your project you can do the following:
> to("jdbc:something").setBody(new
> GroovyExpression("request.body.collectEntries {[(it.COLUMN_A): it]}"))
>
> Otherwise you'll have to use a custom processor.
>
> Hope this helps,
>
> Antoine.
>
>
> 2015-03-16 17:43 GMT+01:00 angelo.rlcosta <[hidden email]
> <http:///user/SendEmail.jtp?type=node&node=5764229&i=0>>:
>
> > HI Guys,
> >
> > i'm using jdbc component to perform a selectList. I've noticed that
> > according to the impl it returns a List<Map&lt;String, Object>> data =
> > extractResultSetData(rs);
> >
> > Is there any type of transformation i can perform to have data like
> > Map<String, Map&lt;String, Object>> so instead of a List i have a Map
> where
> > the key is for example List[i].COLUMN_A and then the inner map the same
> as
> > the Map in the List.
> >
> > Thanks in advance,
> >
> >
> >
> >
> > --
> > View this message in context:
> >
> http://camel.465427.n5.nabble.com/Possibility-of-jdbc-component-when-performing-a-select-to-return-a-map-tp5764228.html
> > Sent from the Camel - Users mailing list archive at Nabble.com.
> >
>
>
> ------------------------------
>  If you reply to this email, your message will be added to the discussion
> below:
>
> http://camel.465427.n5.nabble.com/Possibility-of-jdbc-component-when-performing-a-select-to-return-a-map-tp5764228p5764229.html
>  To unsubscribe from Possibility of jdbc component when performing a
> select to return a map, click here
> <http://camel.465427.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5764228&code=YW5nZWxvLnJsY29zdGFAZ21haWwuY29tfDU3NjQyMjh8OTY0MzQzODU=>
> .
> NAML
> <http://camel.465427.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>




--
View this message in context: 
http://camel.465427.n5.nabble.com/Possibility-of-jdbc-component-when-performing-a-select-to-return-a-map-tp5764228p5764261.html
Sent from the Camel - Users mailing list archive at Nabble.com.