[
https://issues.apache.org/jira/browse/DERBY-2888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12520368
]
Aaron Digulla commented on DERBY-2888:
--------------------------------------
Sorry, but I mixed that up. 2193 was to get the line number (which is fixed).
This bug here is specifically to get the column name. So it's not a duplicate.
I was specifically asked in 2193 to open a new bug (-> this one here).
> 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.
