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.
Best regards and thanks for the help
Stefan
