[DELTASPIKE-871] save() and findByxxx() in same transaction gives constraint violation exception

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Cannot Reproduce
• Affects Version/s: 1.2.0
• Component/s: Data-Module
• Environment: Windows-7, Java-8, Netbeans-8.0.2
• Assignee: Daniel Cunha
• Reporter: Md Kamaruzzaman
• Created: 08/Apr/15 12:53
• Updated: 01/Jul/15 14:43
• Resolved: 01/Jul/15 13:08

Description

It seems like when in the same EJB transaction, save() and findByxxx() is called, then delta-spike inserts the entity twice [once in save() and other time in findByxxx()] and gives a constraint violation exception.

After some debuggin, it seems like save() gives a "INSERT" query in DB and findByxxx() method calls a flush which again gives the same "INSERT" query in DB [INSERT query from save() is not removed from EntityManager] and gives constraint violation exception.