Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 4BA749EAF for ; Wed, 30 Nov 2011 14:49:10 +0000 (UTC) Received: (qmail 98394 invoked by uid 500); 30 Nov 2011 14:49:10 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 98361 invoked by uid 500); 30 Nov 2011 14:49:09 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 98354 invoked by uid 99); 30 Nov 2011 14:49:09 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 30 Nov 2011 14:49:09 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=FREEMAIL_FROM,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of bpendleton.derby@gmail.com designates 209.85.210.172 as permitted sender) Received: from [209.85.210.172] (HELO mail-iy0-f172.google.com) (209.85.210.172) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 30 Nov 2011 14:49:02 +0000 Received: by iaeo4 with SMTP id o4so1054977iae.31 for ; Wed, 30 Nov 2011 06:48:41 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type:content-transfer-encoding; bh=RI7/O8O3iqDtyoukNR9adVZ7BcbIE5/QL5+FwnmmJKk=; b=hVzCdf5PlF7NO/IS6XVqDA6iWhVftnHoouqIAV8/81kpHGPcjHCrn88uGG7vbkVn2X /keocQCDDSsUzvOu7MyPvH1AOiUlbBVPJLk7tRRCWVwWE0FORr+AzpvhBjGey9jSNgz9 hosaQ6KD7Q7gOHCbeOUoOy1WnyxLeM/VPjlnw= Received: by 10.43.50.67 with SMTP id vd3mr3137564icb.10.1322664521497; Wed, 30 Nov 2011 06:48:41 -0800 (PST) Received: from [192.168.0.100] (c-67-170-231-73.hsd1.ca.comcast.net. [67.170.231.73]) by mx.google.com with ESMTPS id eh34sm8897679ibb.5.2011.11.30.06.48.39 (version=TLSv1/SSLv3 cipher=OTHER); Wed, 30 Nov 2011 06:48:40 -0800 (PST) Message-ID: <4ED64242.2060500@gmail.com> Date: Wed, 30 Nov 2011 06:48:34 -0800 From: Bryan Pendleton User-Agent: Mozilla/5.0 (X11; Linux i686; rv:8.0) Gecko/20111124 Thunderbird/8.0 MIME-Version: 1.0 To: Derby Discussion Subject: Re: Error on CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE References: <32884390.post@talk.nabble.com> <4ED63DDD.4090006@oracle.com> In-Reply-To: <4ED63DDD.4090006@oracle.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit >> Exception in thread "main" java.sql.SQLException: Import error on line 1 of > > The error message is telling you that the error is on the very first line of the data file. Sometimes spreadsheet exports contain a special "column headers" row at the very start. Usually your spreadsheet tool has a checkbox where you can tell it, when exporting the CSV file, to skip the column headers. thanks, bryan