Enforced sequence does not work with concurrent access
------------------------------------------------------
Key: OFBIZ-3557
URL: https://issues.apache.org/jira/browse/OFBIZ-3557
Project: OFBiz
Issue Type: Bug
Components: framework
Affects Versions: Release Branch 9.04, SVN trunk
Reporter: Wickersheimer Jeremy
There is a fundamental issue with enforced sequences (for orders, invoices, etc
..) and concurrency.
For example if two users are creating an order at the same time one of them
will see the creation fail with a PK error. The problem is that the
"getNextXXXId" rely on the party accounting preference entity, but there is
absolutely no guarantee that the last number in the sequence gets updated
before another service can read it.
This is at best very annoying when used only internally but may be unpractical
for e-commerce sites.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
