Metacat

We're going to use sequence and db trigger before insert for nodeid generation,
because it is the fastest way.
But here comes the problem with getting the right generated number from the
sequence (select seq.currval ...) b' there time between the sequence generation
and selection
insert into xml_nodes ...
db trigger: put nextval from seq ...
select currval from the seq ...
If 2 users make a call to writeChildNodeToDb method and the second user
insert into xml_nodes before the first one get currval from the sequence
definitely the first user will get wrong number (the number that belongs to the
second user):
1 user: insert into xml_nodes (1 ...)
2 user: insert into xml_nodes (2 ...)
1 user: select seq.currval -> 2
2 user: select seq.currval -> 2
Approach 1/ every request to the servlet starts a new tread.
Our servlet creats a new DBWriter obj on every request.
Put insert into xml_nodes & select seq.curval in one method:
DBSAXNode.writeChildNodeToDB() and make it
static synchronized DBSAXNode.writeChildNodeToDB()
(should investigate)
Approach 2/ having single DBWriter obj for the servlet but everything inside
DBWriter should be synchronized and tread safe
(very complicated and unefficient)
Approach 3/ call to one DBWriter static method from the servlet.
This will avoid creating many obj instances for the DBWriter but will still
create instances of the other classes.
And still need static synchronized DBSAXNode.writeChildNodeToDB()