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,