Hibernate version: 2.1
MySQL 5.0 Alpha
Dear All,
I'm having a problem in inserting a new record concurrently. The following is the the scenario:
1. I have two users (User A and User B) running same application Z on two
separate PCs.
2. User A and User B runs the application Z at the same time, same module
X. And here is the complicated part.
Quote:
User A and User B both "entered their client data" and "saved it one after the another". The error as the following appeared:
"Duplicate key or integrity constraint violation".
This problem was found when they seem to access the same table and started adding data from the same row:
1. When both of them access the database at table XYZ,
hibernate found the last row is at row 10 (for user A and user B).
2. When both the user saves the data, the error appears and user B have
his/her data intact and user B lost his data.
Kind Regards,
Dragoncity99