Hibernate version: 2.1.6
Mysql 4.0.x
consider the following table 'machine', where id_machine is autoincrement.

The relevant part of the mapping in the hbm file looks like this.


* Consider 2 different sessions on different machines trying to insert into the table at the same time, the auto increment logic would get the value '3' for both the sessions.
* When tried to commit, only the first session succeeds while the other failes with net.sf.hibernate.exception.ConstraintViolationException.

Is there a way to avoid this?

Thanks for the great tool.
- Vinay

use generator="native" or generator="identity" - and read the reference manual on what generator does what.