Hello,

I am experiencing a weird behavior where part of a long transaction I get duplicate ids.

I am using Jboss 7.2.0 and Hibernate 4.0.1.Final.

I have tried/experimented many solutions in vain: flush() after persist() and surrounding the insert with an embedded transaction (new).

I am also using the Hxtt driver for MS access where the problem is not reproduced.

Regards.

@TableGenerator(
table = "SEQUENCE_TABLE", name = "seq1", pkColumnName = "seq_name",
valueColumnName = "seq_val", pkColumnValue = "seq1", allocationSize = 1,
initialValue = 1001)
@Id
@GeneratedValue(
strategy = GenerationType.TABLE, generator = "seq1")
public Long getId() {
return super.getId();
}