metacat docid and rootnodeid not generated in a safe manner
when a document or node are inserted into their respective tables, a trigger
generates an ID number for the PK from a SEQUENCE, which is then retreived by
examining the sequences "currval" attribute. If another db insertion was done
(by another user), then currval would return the wrong ID number. Basically,
need to return the generated ID number as part of the same transaction as the
Updated by Jivka Bojilova over 22 years ago
Problem fixed for docid assignment.
Using AccessionNumber class for docid generation from DBSAXDocument class.
Now docid is created in safe manner, because before with sequence
multiple user connections could get wrong currval from the sequence, ie not
xml_acc_numbers table keep track of docid values which are unique.
Accession # generation is runned in different connection with auto commit mode
in order to provide immediate visualization of the generated # to other user's
Need more work for nodeid - refer to bug #25 about safe nodeid generation
There are nothing about rootnodeid. The problem is for nodeid.