[
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.
