Lost update on seam-gen when two users update

[philip142au.philip_andrew.hotmail.com]

Hi,

I was just testing my seam-gen code for the case where two users edit the same object.

User A edits ID 1 and makes a change
User B edits ID 1 and makes a change
User A saves
User B saves
User A views the ID 1 item, and see's that user A's changes are lost and user B's changes have over-written

This is a problem.

Can anyone suggest a solution?

Thanks, Philip

[meetoblivion]

do the entities have an @Version on the anywhere? you probably should be using that.

[philip142au.philip_andrew.hotmail.com]

Ok thanks, since I use seam-gen to generate the JPA from the mysql database, all I had to do is add a version INT column to my tables.
The hibernate reverse engineer then automatically added @Version.

Although I am not happy that this sort of thing is so ... undeclared, the names of table columns and tables is important. For example I can't have a column called content, it causes problems. Theres a few other table restrictions for their names.