db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aa1 <...@3dplmsoftware.com>
Subject Re: CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE
Date Fri, 30 Apr 2010 10:57:44 GMT

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 <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
> 
> 

-- 
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.


Mime
View raw message