Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <20653843.1187295690418.JavaMail.jira@brutus>
Date: Thu, 16 Aug 2007 13:21:30 -0700 (PDT)
From: "Bryan Pendleton (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (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


    [ https://issues.apache.org/jira/browse/DERBY-2888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12520355 ] 

Bryan Pendleton commented on DERBY-2888:
----------------------------------------

Is BUG1.dbe partial or incomplete? I don't get any errors when I import it. Instead, I just get "0 rows inserted".


> 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: Improvement
>          Components: Tools
>    Affects Versions: 10.2.2.0
>            Reporter: Aaron Digulla
>            Priority: Minor
>         Attachments: BUG1.dbe, 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.