|
On Jun 15, 2009, at 4:29 PM, Vince Clark wrote:
> I am integrating with another system to pull in new customer records
> on a nightly basis. Two questions:
>
> I want new customers to be committed to the OFBiz database with each
> iteration, not waiting until the entire list has iterated before
> committing all the new customers. If I run into an error with a
> record I want to write it to a log file or database table and keep
> going. So one bad record shouldn't disrupt the entire batch.
Sounds like you need to put the per-row logic in a separate service
that has the require-new-transaction=true attribute set. Then that
logic will be in a separate transaction and will not be tied to other
things to fail/succeed together.
> Next, with each successful pass thru the iterator I want to update
> that customer record on the other system. The customer table in that
> system has a flag that is set when the import is successful. My
> question is that using <store-value> seems to update the entire
> record. Is there a way to just do an update of a single field?
Just get a fresh value from the database, change the field(s) you
want, and store that one.
-David
|