Store CSV file to Mysql DB using Camel Bindy and Camel -sql got stucked

[bhagavan]

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.