Hi All, Is this same functionality possible in derby? While importing large data from file its throws Exception because of CHECK constraint instead , I want it to import only data which satisfy given constraint and ignore other data,is this possible with derby?
Regards, AA1 Dag H. Wanvik wrote: > > 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 > > -- View this message in context: http://old.nabble.com/CALL-SYSCS_UTIL.SYSCS_IMPORT_TABLE-tp27391949p28410945.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
