db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag.Wan...@Sun.COM (Dag H. Wanvik)
Subject Re: CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE
Date Mon, 01 Feb 2010 23:48:56 GMT
Stefan B├╝hlmann <stefan.buehlmann@joebox.org> writes:

> Hi everybody!
>
> I'm using the wunderfull fast function SYSCS_IMPORT_TABLE to import
> big csv data. Sadly the csv data isn't always correct:
>
> org.springframework.jdbc.UncategorizedSQLException: StatementCallback;
> uncategorized SQLException for SQL [CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE
> (null,'PARAMS2','C:\database\analysis\711\run2\concrete analysis
> files\params.csv',null,null,null,0)]; SQL state [XIE0R]; error code
> [20000]; Import error on line 159,870 of file
> C:\database\analysis\711\run2\concrete analysis files\params.csv:
> INSERT on table 'PARAMS2' caused a violation of foreign key constraint
> FK_HANDLES2' for key (3573).  The statement has been rolled back. ;
> nested exception is java.sql.SQLException: Import error on line
> 159,870 of file C:\database\analysis\711\run2\concrete analysis
> files\params.csv: INSERT on table 'PARAMS2' caused a violation of
> foreign key constraint 'FK_HANDLES2' for key (3573).  The statement
> has been rolled back.
>
> Therefore I would like to ask if it is possible to configure derby
> somehow to ignore invalid lines and continue the importing.

I am not aware of such a functionality. Feel free to file an
improvement request in a JIRA; this is open source, maybe someone will
pick it up!

Dag

Mime
View raw message