camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From imranrazakhan <imranrazak...@gmail.com>
Subject CSV and SQL Component for Batch Processing
Date Wed, 29 Apr 2015 09:36:59 GMT
Hi,

I am doing batch insertion into db from CSV file like

        from("file:mycsv")            
        .unmarshal().csv()    
       .to("sql:insert into mytable (value1, value2) Values (#,
#)?batch=true") 
       .end();      

It works fine if CSV columns and Table columns are same, but my CSV has 10
column and Table has 7.

Is there any way to skip last 3 columns from CSV before insertion?

I can use bindy component but i am looking for option in CSV

Regards,



--
View this message in context: http://camel.465427.n5.nabble.com/CSV-and-SQL-Component-for-Batch-Processing-tp5766475.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Mime
View raw message