camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bhagavan <suryabhagavanpad...@gmail.com>
Subject Store CSV file to Mysql DB using Camel Bindy and Camel -sql got stucked
Date Sat, 22 Feb 2014 08:57:45 GMT
Hi, I'm unable to store CSV file into Data base with Camel bindy 

<camel:route id="bindy-csv-unmarshalling-example" autoStartup="true">
			<camel:from uri="file:inbox/csv?noop=true&amp;delay=10" />
			<camel:log message="CSV to DB Using Bindy" loggingLevel="WARN"/>
			<camel:split streaming="true">
				<camel:tokenize token="\n" group="1" />
				<camel:unmarshal ref="bindyDataformat" >
					<camel:bindy type="Csv"  locale="en-us"
classType="org.apache.camel.example.fixedlength.Employee"/>
			</camel:unmarshal>
			<camel:log message="OUTPUT FOR CSV Record ::: ${body}"
loggingLevel="WARN" />
		    <transform>
			<simple>${body[0]}</simple>
				</transform>
		    <camel:to uri="sql:insert into player (id, name, city) values
(:#id,:#name,:#city)?dataSourceRef=dataSource"/>
		        </camel:split>
			<camel:stop/>
		</camel:route>


I'm facing the following error

[ #0 - file://inbox/fixedlength] d-length-unmarshalling-example WARN  OUTPUT
FOR CSV Record ::: Employee [Id=6, name=chand, city=tanuku]
[ #0 - file://inbox/fixedlength] DefaultErrorHandler            ERROR Failed
delivery for . Exhausted after delivery attempt: 1 caught:
org.apache.camel.language.bean.RuntimeBeanExpressionException: Failed to
invoke method: [0] on null due to: java.lang.IndexOutOfBoundsException: Key:
0 not found in bean: Employee [Id=6, name=chand, city=tanuku] of type:
org.apache.camel.example.fixedlength.Employee using OGNL path [[0]]
org.apache.camel.language.bean.RuntimeBeanExpressionException: Failed to
invoke method: [0] on null due to: java.lang.IndexOutOfBoundsException: Key:
0 not found in bean: Employee [Id=6, name=chand, city=tanuku] of type:
org.apache.camel.example.fixedlength.Employee using OGNL path [[0]]
	at
org.apache.camel.language.bean.BeanExpression.evaluate(BeanExpression.java:117)
	at
org.apache.camel.language.bean.BeanExpression.evaluate(BeanExpression.java:132)

Thanks in Adavance



--
View this message in context: http://camel.465427.n5.nabble.com/Store-CSV-file-to-Mysql-DB-using-Camel-Bindy-and-Camel-sql-got-stucked-tp5747812.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Mime
View raw message