Mailing-List: contact users-help@camel.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@camel.apache.org
Received-SPF: pass (nike.apache.org: domain of willem.jiang@gmail.com
 designates 209.85.214.173 as permitted sender)
Message-ID: <4F585E43.5090503@gmail.com>
Date: Thu, 08 Mar 2012 15:22:43 +0800
From: Willem Jiang <willem.jiang@gmail.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7;
 rv:10.0.2) Gecko/20120216 Thunderbird/10.0.2
MIME-Version: 1.0
To: users@camel.apache.org
Subject: Re: Need help to load csv into database
References: <1331157743172-5545754.post@n5.nabble.com>
In-Reply-To: <1331157743172-5545754.post@n5.nabble.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

I think you can user the bean to do the below job yourself. 
	<camel:split>
 		<camel:tokenize token=","/>
 		<camel:to
 			uri="sql:INSERT INTO mytable (id, name, event, time)
 			VALUES (#, #, #, #)?dataSourceRef=myDataSource"/>
 	</camel:split>

You just need to read the message body an split the message, put it 
into sql parameter and call the jdbc yourself.

On Thu Mar  8 06:02:23 2012, brbornia wrote:
> Hello guys,
>
> I'm just starting with camel, so sorry to bother you with a must likely
> dummy question.
>
> I am trying to load a csv file into database with something like this:
>
> <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/>
> 	<camel:split streaming="true" parallelProcessing="true">
> 	<camel:tokenize token="\n" />
> 	<camel:split>
> 		<camel:tokenize token=","/>
> 		<camel:to
> 			uri="sql:INSERT INTO mytable (id, name, event, time)
> 			VALUES (#, #, #, #)?dataSourceRef=myDataSource"/>
> 	</camel:split>
> 	</camel:split>
>      </camel:route>
> </camel:camelContext>
>
> And I know that will not work because I separated the csv line into several
> messages when what I want is simple convert that line to an array or
> something like that, but I just do not know how to do it.
>
> A friend told me how to do it converting the csv lines into beans and
> inserting them with JPA, but since I will be loading huge csv files very
> often, I am concerned about unnecessary memory and processing use, so I
> would like to do it without creating several objects.
>
> Can you please help me?
>
> Thank you in advance,
> Bruno
>
> --
> View this message in context: http://camel.465427.n5.nabble.com/Need-help-to-load-csv-into-database-tp5545754p5545754.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>


-- 
Willem
----------------------------------
FuseSource
Web: http://www.fusesource.com
Blog:    http://willemjiang.blogspot.com (English)
         http://jnn.javaeye.com (Chinese)
Twitter: willemjiang 
Weibo: willemjiang