Actions
Bug #2515
closedLoader gets sequence values when loading old data
Start date:
08/15/2006
Due date:
% Done:
0%
Estimated time:
Bugzilla-Id:
2515
Description
The XML Loader appears to get the next sequence value for each element it encounters, even if the element is not added to the database because it's a recognized entity.
For example, if I have 50 party elements in a document and the maximum party_ID in VegBank is 100 before a load, each party element gets the next sequence value, from 101-150. Even if no party elements are added, or only one or two, the next load will begin with Party_ID=151.
We should only get the next value off the sequence if we are inserting a new record.
Updated by Michael Lee about 18 years ago
not anymore!
Loader now doesn't get the new PK value until it is SURE it is a new record (i.e. not already in XML, and not matched to accessionCode in db already)
Actions