Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 33353 invoked from network); 2 Jul 2007 15:33:26 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 2 Jul 2007 15:33:26 -0000 Received: (qmail 71451 invoked by uid 500); 2 Jul 2007 15:33:29 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 71413 invoked by uid 500); 2 Jul 2007 15:33:28 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 71401 invoked by uid 99); 2 Jul 2007 15:33:28 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Jul 2007 08:33:28 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Jul 2007 08:33:25 -0700 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 05D927141EF for ; Mon, 2 Jul 2007 08:33:05 -0700 (PDT) Message-ID: <33550467.1183390385020.JavaMail.jira@brutus> Date: Mon, 2 Jul 2007 08:33:05 -0700 (PDT) From: "Aaron Digulla (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Updated: (DERBY-2888) Useless error message during import: Invalid character string format for type INTEGER. In-Reply-To: <389293.1183389604618.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-2888?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aaron Digulla updated DERBY-2888: --------------------------------- Attachment: (was: BUG1.dbe) > Useless error message during import: Invalid character string format for type INTEGER. > -------------------------------------------------------------------------------------- > > Key: DERBY-2888 > URL: https://issues.apache.org/jira/browse/DERBY-2888 > Project: Derby > Issue Type: Bug > Components: Tools > Affects Versions: 10.2.2.0 > Reporter: Aaron Digulla > Priority: Minor > Attachments: BUG1.ddl > > > When you try to import the attached data file into derby using SYSCS_UTIL.SYSCS_IMPORT_DATA('DERBY', 'BUG1', null, null, 'bug1.dbe', ';', '"', 'Cp1252', 1), you get the error: Invalid character string format for type INTEGER.' was thrown while evaluating an expression. > If a table has many columns and many rows are imported, it is impossible to figure out where the error is in the input file. Please provide the column name and the line number in the error message. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.