Ok guys,I just found what I wanted.

Here is the code:

<camel:camelContext xmlns="http://camel.apache.org/schema/spring";>
                
<camel:package>com.test.integration.camel.spring.poc</camel:package>
                <camel:route>
                        <camel:from
                        
uri="file:/media/arq/work/workspace/servicemix/datafeed/from?delete=true" />
                        <camel:split streaming="true" parallelProcessing="true">
                                <camel:tokenize token="\n" />
                                <camel:unmarshal>
                                        <camel:csv/>
                                </camel:unmarshal>
                                <camel:to uri= "sql:INSERT INTO mytable (id, 
name, event, time) 
                                                                                
        
VALUES (#, #, #, #)?dataSourceRef=feedDS"/>
                        </camel:split>
                </camel:route>
        </camel:camelContext>

Thanks anyway for your tips,
Bruno

--
View this message in context: 
http://camel.465427.n5.nabble.com/Need-help-to-load-csv-into-database-tp5545754p5550700.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Reply via email to