From: Paul Lutus <nospam@...>
Date: 2006-09-28T00:50:15+09:00
Subject: Re: Commit when error

Jose Montero wrote:

/ ...

>> Obviously, once an error condition comes up, trying to commit then is
>> too
>> late -- the prevailing error condition prevents the commit from being
>> carried out.
> --------------------------------------------------------------------
> Well the thing here is that if i commit each 5 records, and i get an
> error loading the 4th record, those 4 records wont commit, wont load. I
> think the thing here is how to recover from an error, how to commit the
> records that were already loaded to the database.....is it possible?

Apparently not. I want to emphasize this is just at first glance, without
running any tests. To me it would seem better to try to figure out why the
error is coming up. You obviously have a consistent though random error
that isn't going away, and that is undermining your database processing. I
would want to know why.

It looks as though the error is on the database side (not the file reading
side), and since the database is in an error state after the failed query,
it cannot commit either. I think you need to analyze the error itself,
rather than try to get past it.

-- 
Paul Lutus
http://www.arachnoid.com