General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Definitely a case of having your isolation level set at Read Committed and you are trying to get access to a pending record. This is why you have Tx's open for a short time. In practice, nobody would be trying to access the newly created record anyway. If it is possible for a new record to fall in the range of records that could be queried, you may want to try read uncommitted - or more commonly known as dirty reads.
It depends on how current your data needs to be. This also raises the issue of the special error/exception handing needs C/S apps need.
HTH,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only