db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-2888) Conversion errors during IMPORT_DATA should identify the column for which data conversion failed
Date Thu, 16 Aug 2007 20:55:30 GMT

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


Mime
View raw message