You'll see in the OFBiz demo data that for one time loading we usually
just keep the numbers under 10000 so they don't conflict.
If you'll be doing it a lot, you might try a prefix per data source
(isolated key spaces basically). The entity engine even support doing
this for you (on the delegator element of the entityengine.xml file).
-David
On Feb 17, 2009, at 9:57 PM, Kumaraswamy nandipati wrote:
Hi Friends,
This is Kumaraswamy.
I am using ofbiz for my e-commerce application. I like the option
data seed
through XML import which is provided in ofbiz.
we are seeding the data for *InventoryItem* entity though XML import
since
eariler. By doing this, The sequence Numbers are not updating in *
SequenceValueItem*. Now I am not able to create *InventoryItem*
through
events(either JAVA or mini-lang), its giving duplicate primary key
error,
because of the sequence numbers are already used.
Of course, by doing max(sequenceId)+1 and store. That will be bad
idea what
I feel. Is there any alternate for this. May be an ECA to update
*SequenceValueItem
*entity with new seqId for every InventoryItem XML import.
Generally, we do XML imports frequently for few entities. How to
implement
generic ECA which will update *SequenceValueItem *for every entity
which
uses sequenceId. Any code help will be appriciated.
Thanks in Advance
--
Thanks,
Kumaraswamy.N
