db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stefan B├╝hlmann <stefan.buehlm...@joebox.org>
Subject CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE
Date Sun, 31 Jan 2010 11:32:45 GMT
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

Mime
View raw message