Mailing-List: contact users-help@camel.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@camel.apache.org
Received-SPF: pass (athena.apache.org: domain of raul@fusesource.com
 designates 74.125.245.88 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <1321425175373-4996795.post@n5.nabble.com>
References: <1321362774466-4994243.post@n5.nabble.com>
 <1321362800225-4994244.post@n5.nabble.com>
 <CAGB5yNkP67MLA98BNj5mkM0FYjrfQ-H0dbDByEn_qGbZjUnk2w@mail.gmail.com>
 <1321366989183-4994400.post@n5.nabble.com>
 <CALvzYd86_fQjon3si3+v8kazxQuowXy4O7F-Dm6FCk1n-WZ1tw@mail.gmail.com>
 <1321425175373-4996795.post@n5.nabble.com>
From: Raul Kripalani <raul@fusesource.com>
Date: Wed, 16 Nov 2011 13:36:54 +0000
Message-ID: 
 <CAGgTx3iqe4VG57nOxe_4tJkWvjesm_Qfph3k996r5pw_8GCjjA@mail.gmail.com>
Subject: Re: How can I update database table by using camel routing?
To: users@camel.apache.org
Content-Type: multipart/alternative; boundary=f46d044469b7b26abf04b1da331d

--f46d044469b7b26abf04b1da331d
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi folcadi,

As a side note, our peer Charles Moulliard presented a webinar a few weeks
ago that digs deep into Persistence with Camel, comparing the wide range of
options that Camel offers you to achieve this: camel-jdbc, camel-sql,
camel-jpa, etc.

You can watch the webinar [1] to understand the trade-offs of going one way
or another for your use case. The examples are also downloadable from the
same site.

Additionally, Part II next week will delve into transactions (standalone
and XA), which may be of interest to you.

[1] http://fusesource.com/resources/video-archived-webinars/.

-- Ra=FAl.

On 16 November 2011 06:32, focaldi <ferit.ocaldi@tav.aero> wrote:

> Thanks for your advice Christian, another thanks for Claus :)... I change=
d
> my
> code like below and it works fine. Now, I wanna ask another question :
> Which
> one is the best solution in your opinion?
>
> public class RouteDatabaseToJms extends RouteBuilder {
>        @Override
>        public void configure() throws Exception {
>
>        DataSource ds =3D this.getContext().getRegistry().lookup("dataSour=
ce",
> DataSource.class);
>         this.getContext().getComponent("sql",
> SqlComponent.class).setDataSource(ds);
>
>
>        //final JdbcTemplate jdbc =3D new JdbcTemplate(ds);
>
>                final ProducerTemplate template =3D
> this.getContext().createProducerTemplate();
>
>        from("timer://foo?period=3D60000").setBody(constant("select * from
> AIRPORT")).to("jdbc:dataSource").
>        process(new Processor(){
>                        @Override
>                        public void process(Exchange exchange) throws
> Exception {
>                                ArrayList<HashMap&lt;String, Object>> data=
 =3D
> exchange.getIn().getBody(ArrayList.class);
>                                for (HashMap<String, Object> item : data){
>
>  System.out.println("DATABASE:::item.IATA_CODE
> :"+((String)item.get("IATA_CODE")));
>                                }
>                        }
>        }).to("jms:queue:airport");
>
>        from("jms:queue:airport").process(new Processor(){
>
>                        @Override
>                        public void process(Exchange exchange) throws
> Exception {
>
>                                ArrayList<HashMap&lt;String, Object>> data=
 =3D
> exchange.getIn().getBody(ArrayList.class);
>                                for (HashMap<String, Object> item : data){
>
>  template.sendBody("direct:update",(BigDecimal)item.get("ID"));
>                                        //jdbc.update("update airport set
> description_tr=3D'tamam1' where
> id=3D?",new Object[]{(BigDecimal)item.get("ID")});
>
>  System.out.println("JMS:::item.IATA_CODE
> :"+((String)item.get("IATA_CODE")));
>                                }
>                        }
>
>        });
>
>         from("direct:update").to("sql:update airport set
> description_tr=3D'okkk'
> where id=3D#");
>
>        }
>
> }
>
> --
> View this message in context:
> http://camel.465427.n5.nabble.com/How-can-I-update-database-table-by-usin=
g-camel-routing-tp4994243p4996795.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>

--f46d044469b7b26abf04b1da331d--