[OFBIZ-2353] SequenceUtil may generate duplicate IDs in Load Balancing mode

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Release Branch 4.0, Release Branch 09.04, Trunk
• Fix Version/s: Release Branch 10.04, 14.12.01, 13.07.01
• Component/s: framework
• Assignee: Jacopo Cappellato
• Reporter: Philippe Mouawad
• Created: 24/Apr/09 16:18
• Updated: 20/Dec/14 14:00
• Resolved: 01/Sep/14 16:07

Description

If Ofbiz is deploy on 2 servers in Load Balancing Mode
SequenceUtil will generate duplicate IDs because synchronization is done at JVM level instead of doing it in DB.

A good replacement implementation would be:
org.hibernate.id.enhanced.TableGenerator

But it would involve a dependency on Hibernate

Philippe
www.ubik-ingenierie.com

Issue Links

• is depended upon by: OFBIZ-3557 Enforced sequence does not work with concurrent access