Bug #18
closedmetacat docid and rootnodeid not generated in a safe manner
0%
Description
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
insertion.
Updated by Matt Jones over 24 years ago
Reassigned bug to bojilova. She will fix this bug by chnaging docid assignment
to the AccessionNumber class, and will find a fix for the problem when the
xml_nodes.nodeid is being assigned.
Updated by Jivka Bojilova over 24 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
their own.
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
connections.
Need more work for nodeid - refer to bug #25 about safe nodeid generation
There are nothing about rootnodeid. The problem is for nodeid.