Return-Path: 
 <users-return-47111-apmail-camel-users-archive=camel.apache.org@camel.apache.org>
X-Original-To: apmail-camel-users-archive@www.apache.org
Delivered-To: apmail-camel-users-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 48ECA101BE
	for <apmail-camel-users-archive@www.apache.org>;
 Sat, 22 Feb 2014 09:08:25 +0000 (UTC)
Received: (qmail 99331 invoked by uid 500); 22 Feb 2014 09:08:22 -0000
Delivered-To: apmail-camel-users-archive@camel.apache.org
Received: (qmail 98307 invoked by uid 500); 22 Feb 2014 09:08:21 -0000
Mailing-List: contact users-help@camel.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@camel.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@camel.apache.org>
List-Post: <mailto:users@camel.apache.org>
List-Id: <users.camel.apache.org>
Reply-To: users@camel.apache.org
Delivered-To: mailing list users@camel.apache.org
Received: (qmail 98072 invoked by uid 99); 22 Feb 2014 09:08:21 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 22 Feb 2014 09:08:20 +0000
X-ASF-Spam-Status: No, hits=0.6 required=5.0
	tests=RCVD_IN_DNSWL_LOW,SPF_PASS,URI_HEX
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of claus.ibsen@gmail.com
 designates 209.85.219.46 as permitted sender)
Received: from [209.85.219.46] (HELO mail-oa0-f46.google.com) (209.85.219.46)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 22 Feb 2014 09:08:17 +0000
Received: by mail-oa0-f46.google.com with SMTP id n16so5494706oag.5
        for <users@camel.apache.org>; Sat, 22 Feb 2014 01:07:56 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type;
        bh=PHD4pcSrklXNFP9PQeS5EScYmD11mibz+HSVXxC9ylg=;
        b=bYubXYBvWC8tNPGGqUIgJS/76iCn8YopkdaGYZTELy724TNQenDdOhq7d/rnUoV1NZ
         uDObU1R36CZ7BUcb044BU/0UnhUmoc6yLe1tVG8g/xGTEJVV65AQdWTiQyNoU9E7H8yG
         x+UtKnpCA8vGZt4HDnJE9qzXhNuNXk2CWw9dj9JJI0nnpjHpm2i8Eew4THXZ3qLEXUcV
         w4E1J7fNFkaD12TW2N0WOPezZcowCKUC04ZYuAFrbNkV1zOQ1KtsMyR/UMw00f1mtyQC
         3oTM/MUxgCJsIhCGT93m5W/Ro3lv64y6lHNn7rW3yLufJla1t6fswfmw97yCPRthBNos
         qXFA==
X-Received: by 10.182.102.7 with SMTP id fk7mr9606331obb.28.1393060076590;
 Sat, 22 Feb 2014 01:07:56 -0800 (PST)
MIME-Version: 1.0
Received: by 10.60.61.17 with HTTP; Sat, 22 Feb 2014 01:07:36 -0800 (PST)
In-Reply-To: <1393059465771-5747812.post@n5.nabble.com>
References: <1393059465771-5747812.post@n5.nabble.com>
From: Claus Ibsen <claus.ibsen@gmail.com>
Date: Sat, 22 Feb 2014 10:07:36 +0100
Message-ID: 
 <CAGB5yNnHQspiRPWoHtrL18-RmnLvXKz2+=eoEGMAPBJiaq1K5A@mail.gmail.com>
Subject: Re: Store CSV file to Mysql DB using Camel Bindy and Camel -sql got
 stucked
To: "users@camel.apache.org" <users@camel.apache.org>
Content-Type: text/plain; charset=ISO-8859-1
X-Virus-Checked: Checked by ClamAV on apache.org

Hi

I think you need to remove

                    <transform>
                        <simple>${body[0]}</simple>
                                </transform>

On Sat, Feb 22, 2014 at 9:57 AM, bhagavan <suryabhagavanpadala@gmail.com> wrote:
> 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.



-- 
Claus Ibsen
-----------------
Red Hat, Inc.
Email: cibsen@redhat.com
Twitter: davsclaus
Blog: http://davsclaus.com
Author of Camel in Action: http://www.manning.com/ibsen
Make your Camel applications look hawt, try: http://hawt.io