I wonder if someone can help with a design that I have been given to code and I am not sure it will work.
The objective is to insert rows into a database, however before hand we want to use a common validation module. This validation module will check for the existence of the row, if it is found then a reply is sent to the user. However if it is not the designer wants us to use repeatable read so that the "space" or "slot" will not be used by anyone before we then go to another module to do the insert. They are trying to make generic validation modules and insert modules. So we do not want the insert to fail due to the fact another transaction has inserted a row into the databse with the same key.
Hope this makes sense. My question is that on a singleton selection using WITH RR, if this row does not exist will the empty slot be held until the next commit point.