Stefan Bühlmann <[email protected]> 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
