[
https://issues.apache.org/jira/browse/DERBY-2888?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Bryan Pendleton updated DERBY-2888:
-----------------------------------
Description:
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. DERBY-2193 enhanced
IMPORT_DATA to provide the row number which contained the data that could not
be converted, but Derby still does not identify which column had the error.
Please provide the column name in the error message.
was:
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.
Summary: Conversion errors during IMPORT_DATA should identify the
column for which data conversion failed (was: Useless error message during
import: Invalid character string format for type INTEGER.)
Updated summary and description to make it clear that this is a request for the
column name to be added to the error message.
> Conversion errors during IMPORT_DATA should identify the column for which
> data conversion failed
> ------------------------------------------------------------------------------------------------
>
> 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. DERBY-2193 enhanced
> IMPORT_DATA to provide the row number which contained the data that could not
> be converted, but Derby still does not identify which column had the error.
> Please provide the column name 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.
